Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “quits” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

170 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
quits14412235(None) 
duits65021881duits
qubits173710351qubits
quids154917461quids
quiets154014371quiets
quilts154112541quilts
quins144819851quins
quints154316561quints
quips164713371quips
quirts154213551quirts
quit136136511quit_
quite144621461quite
quoits15379681quoits
suits55028051suits
acquits1857292acquits
adits66523712adits
aits46355532_aits
audits72814112audits
aunts55227632aunts
baits76630582baits
bits66148162_bits
brits76433082brits
bruits85714452bruits
bunts75729802bunts
busts75227692busts
buts67247692bu_ts
butts75824252butts
chits105424572chits
crits75527572crits
cubits103714032cubits
cuifs104814692cuifs
cults75022552cults
cunts76125122cunts
cutis77723762cutis
cuts65841152cu_ts
dits56450522_dits
doits66223672doits
ducts85319892ducts
duets65323882duets
duit56241582duit_
dunts65828412dunts
dusts65923562dusts
edits65819032edits
emits75421472emits
equids16439142equids
equips17387192equips
equites162212492equites
equity1838102equity
exits125515912exits
fits76043462_fits
flits85625222flits
frits86129102frits
fruits94512492fruits
gaits65726012gaits
gits55744592_gits
grits65529582grits
guids75516152guids
guilts74111232guilts
gusts65722792gusts
guts56637252gu_ts
hits75545132_hits
hunts86826172hunts
hurts86922822hurts
huts76737442hu_ts
its35538832__its
justs124918262justs
juts115930162ju_ts
kits86441772_kits
knits93914742knits
lits46252492_lits
lunts55826902lunts
lusts55022802lusts
musts75527442musts
muts64839982mu_ts
mutts75120252mutts
nits45741642_nits
nuts45032672nu_ts
obits74617552obits
omits75018262omits
ousts55225702ousts
outs45746962ou_ts
pits66348742_pits
punts75828002punts
puts65641752pu_ts
putts75719272putts
qaids156116312qaids
qats135331342q_ats
qis126934382q_i_s
quads154515842quads
quags154613252quags
quails153412642quails
quais144618392quais
quants153614142quants
quarts154715932quarts
quass144413762quass
quate144521412quate
quays174612042quays
qubit164218992qubit_
quest144121322quest
quests153310352quests
queys17398362queys
quick204311062quick
quicks21389302quicks
quid144922352qui_d
quiet144530732quiet
quietus16286392quietus
quiff201111562quiff
quiffs21135432quiffs
quill148413772quill
quills153811852quills
quilt144125102quilt
quin135823922qui_n
quinsy18386352quinsy
quint144529902quint
quinta153312372quinta
quintas163611712quintas
quinte153414522quinte
quintes164114712quintes
quip154818622qui_p
quipu164811642quipu
quipus17458002quipus
quire144917132quire
quires154015752quires
quirk184011002quirk
quirks19419112quirks
quirt144624232quirt
quitch2036412quitch
quiz224920002qui_z
quods154610222quods
quoins154110582quoins
quoit143819862quoit_
quota145111962quota
quotas15339432quotas
quote143714772quote
quotes153312462quotes
quoth173310352quoth
ruins55822032ruins
runts55927632runts
rusts55026992rusts
ruts44541492ru_ts
shits84731172shits
sits45050202_sits
skits94721862skits
slits56128852slits
snits54124832snits
spits74429552spits
squats153712962squats
squibs17317452squibs
squids16409802squids
squints16339032squints
squirts16348012squirts
suets55126102suets
suints64617782suints
suit45649872suit_
suite54829562suite
suites63727402suites
tits46145042_tits
toits55327472toits
tufts85713272tufts
tuis44829642tui_s
tuts45838452tu_ts
twits86015792twits
units54923432units
uts35534372_u_ts
waits88333522waits
whits115923822whits
wits76044872_wits
writs86624382writs
yurts87216532yurts
zits136030292_zits

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.313570897.8
2DLD Change Limit538001701.36039558.8
3Display Results1701700.0463695.7
 (SQL Overall)1786911701.719103950.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.