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 “zuzim” with Change Limit: [1] [2] [3]

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

191 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
zuzim153487(None) 
fuzil173810702fuzil
zizit13313272zizit
zuz1110622032zuz__
aim57858213__aim
audio62917103audio
audit62527883audit
aulic74420243aulic
auric74521733auric
auris55331533auris
aurum7614963aurum
autism83815333autism
auxin121411913auxin
azuki1864803azuki_
azukis1963733azukis
bedim10313833bedim
bezil163812883bezil
brim85629373_brim
bum75342693bu__m
burin75626063burin
buxom1647153buxom
buzz146617803buz_z
claim95616913claim
cozie163519133cozie
cubic114313423cubic
cubism12348703cubism
cubit94122893cubit
cuif96529143cu_if
culm85822383cu_lm
cum76440163cu__m
cumin94616973cumin
cupid103212783cupid
curia74523773curia
curie74533043curie
curio74221213curio
curium10312503curium
cutie76925933cutie
cutin75022783cutin
cutis77723763cutis
denim85518843denim
dim68146493__dim
duci76422623duci_
dui46433383du_i_
duit56241583du_it
dulia61014983dulia
dunam8313733dunam
duomi8310133duomi
durum8513203durum
enzym1964393enzym
fuci95720313fuci_
fugio9310923fugio
fuji144112003fuji_
fujis15379243fujis
fusil84715323fusil
fuze166422373fuz_e
fuzed185415253fuzed
fuzee175718883fuzee
fuzes175120223fuzes
fuzils18407963fuzils
fuzing194110643fuzing
fuzz158420573fuz_z
fuzzy1929814513fuzzy
glim76026353_glim
goyim1148603goyim
grim76929423_grim
guid66022823gu_id
gum67439533gu__m
hakim14311833hakim
him86247663__him
huic94818053hu_ic
hum85542933hu__m
humic124113243humic
humid114213763humid
huzza1646093huzza
jugum15167473jugum
kelim11912553kelim
kilim11711893kilim
kufi11910653kufi_
kufis1249253kufis
lucid84314573lucid
ludic82912803ludic
lum55542933lu__m
lupin75215843lupin
lurid64618973lurid
maim85831493_maim
maxim165216003maxim
mim76048423__mim
minim97321603minim
mucid104115253mucid
mucin93116823mucin
mujik1866103mujik
mum76643613mu__m
mumm75718863mu_mm
muni65824413muni_
munis75022003munis
murid84520583murid
music94316403music
mutism103211463mutism
muzhik2473523muzhik
muzjik2872703muzjik
muzzy188410603muzzy
nazi136219873nazi_
nazis145216083nazis
nim57142953__nim
nizam16310253nizam
nubia7311233nubia
nudie65118673nudie
nudism9357913nudism
ourie54027303ourie
ouzel144612323ouzel
ouzo133516933ouz_o
ouzos143210413ouzos
oxim131114053_oxim
prim85132203_prim
pubic114513723pubic
pubis94616473pubis
pudic104614563pudic
puli65527623puli_
pulik113613303pulik
pulis74225603pulis
pupil94712983pupil
puri65931443puri_
purin75527593purin
puris75332023puris
purism104715063purism
quai134420393quai_
quail144314363quail
quais144618393quais
qualm163511183qualm
qubit164218993qubit
quid144922353qu_id
quin135823923qu_in
quip154818623qu_ip
quit136136513qu_it
quiz224920003qu_iz
quoin144012323quoin
quoit143819863quoit
rim56052273__rim
ruin47430513ru_in
rum56644643ru__m
runic73615773runic
rutin55421343rutin
scrim95419733scrim
shim95827863_shim
sim56553143__sim
skim105322513_skim
slim66631963_slim
sozin14514543sozin
suit45649873su_it
sum56346013su__m
surimi839103surimi
swim96221403_swim
trim65329523_trim
tui37034023tu_i_
tuis44829643tu_is
tulip71111693tulip
tumid84114023tumid
tunic74018223tunic
tupik1149003tupik
tzuris15286913tzuris
um47338833_u__m
umm711921263_u_mm
unit45140073_unit
unzip16207623unzip
uric63624933_uric
vim87437023__vim
vizir17359393vizir
vum85428653vu__m
whim126220533_whim
yomim12510083yomim
yum86132823yu__m
zamia165115213zamia
zayin174512043zayin
zazen1337283zazen
zein135620603z_ein
zig136931903__zig
zin125643773__zin
zip146636223__zip
ziram163912893ziram
zit126049993__zit
ziti136022373ziti_
zitis145815583zitis
zizith1744823zizith
zoic152316073z_oic
zooid15312103zooid
zoom156722103z_oom
zori137722923zori_
zoril143916693zoril
zoris145320013zoris
zowie174313843zowie
zzz1017911913z_z_z

Search took 5 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 Filter178691836670.1061685764.2
2DLD Change Limit836671913.84321771.3
3Display Results1911910.0633031.7
 (SQL Overall)1786911914.01244539.1
 
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.