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 “simoom” 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.

160 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
simoom103750(None) 
simooms1135571simooms
simoon858061simoon
simony1137902simony
simoons937942simoons
sitcom1036902sitcom
abloom1039783abloom
biform1368123biform
bimbo114811873bimbo_
bimbos124610523bimbos
bloom95918973_bloom
boom87435673__boom
broom95022213_broom
diatom939453diatom
dimout9414243dimout
doom76430073__doom
filmdom1562943filmdom
gloom87116523_gloom
groom85317983_groom
idiom899963_idiom
imam81718333_im_am
imaum9139643_imaum
imbosom1343713_imbosom
jibboom2092493jibboom
kimono12105413kimono
kimonos13114633kimonos
limbo95614813limbo_
limbos104712143limbos
limo65529733lim_o_
limos75320813lim_os
lissom837403lissom
loom67035053__loom
mimeo96018683mimeo_
mimeos104511543mimeos
mimosa1036363mimosa
mom78853163__m_om
moo58460513__moo_
mood76332063__mood
mool67533863__mool
moon67140813__moon
moor66628553__moor
moos66051303__moos
moot67653623__moot
nimrod934873nimrod
pompom1436493pompom
rimose8310593rimose
rimous8311913rimous
room66235083__room
saloon64418023saloon
saloop84212583saloop
sambo95118013sambo_
sambos104315193sambos
samosa8510203samosa
schmoos14347513schmoos
school11410723school
scoop95617163s_coop
scoot75729153s_coot
scroop10299773scroop
seldom939403seldom
shalom11810923shalom
shmo95318103shm_o_
shmoes114612103shmoes
shmooze21255263shmooze
shnook1366343shnook
sholom11910113sholom
shoo75929893s_hoo_
shook124920163s_hook
shool84523153s_hool
shoon84022013s_hoon
shoos84226363s_hoos
shoot84235913s_hoot
sicko115315393sicko_
sickos125112033sickos
sickroom1643943sickroom
sigloi737743sigloi
siglos7311473siglos
siglum936563siglum
sigmoid1146113sigmoid
signor73510353signor
silo46037913si_lo_
siloed74615303siloed
silos56029433si_los
sim56553143si___m
sima64730783sim__a
simar74920813sim_ar
simars84916933simars
simas75727553sim_as
simian8811163simian
simile83115633simile
simioid1047993simioid
simious939803simious
simlin8311733simlin
simmer104115353simmer
simnel857023simnel
simoleon10133093simoleon
simp85228773sim__p
simper103616293simper
simple104315173simple
simply133010523simply
simps94719763sim_ps
sims65737173sim__s
siphon1138463siphon
sitcoms1145533sitcoms
sixmo1448303sixmo_
sixmos1534813sixmos
skidoo1136093skidoo_
skidoos1234463skidoos
skimo116312543skim_o_
skimos12548803skim_os
slalom888173slalom
sloop76118913s_loop
smarm95517603s_marm
smock135311673s_mock
smog76317413s_m_og
smogs85112163s_mogs
smoke115015823s_moke
smoky14388683s_moky
smolt74824163s_molt
smooch13266803s_mooch
smoosh11236733s_moosh
smooth11259203s_mooth
smote75820283s_mote
snood64616163s_nood
snook95115573s_nook
snool55118643s_nool
snoop75317173s_noop
snoot55030143s_noot
sodom8814913s_odom
som59153813s___om
somoni8310743somoni
sook84933393s__ook
soon46240503s__oon
soot45761063s__oot
spoof105019013s_poof
spook115416043s_pook
spool75219043s_pool
spoon74719443s_poon
spoor75016353s_poor
stood65517713s_tood
stook95218213s_took
stool55619893s_tool
stoop75821543s_toop
storm76520393s_torm
strook10410303strook
summon1037623summon
sumo67326313sum_o_
sumos75720093sum_os
sunroom947013sunroom
swoon85014783s_woon
swoop105213433s_woop
symbol1336083symbol
symptom1644003symptom
syncom1336093syncom
timolol944113timolol
toom66532933__toom
unmoor836313unmoor
varoom11411413varoom
vroom105312473_vroom
wisdom1235983wisdom
zoom156722103__zoom

Search took 8 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 Filter1786911127160.266671770.7
2DLD Change Limit1127161607.58014870.2
3Display Results1601600.0433720.9
 (SQL Overall)1786911607.88922650.7
 
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.