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

354 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
sholom1191011(None) 
shalom11810921shalom
sholoms1278031sholoms
cholo105217972cholo_
cholos114716852cholos
holm95628112_hol_m
shaloms1288982shaloms
shoo75929892sho_o_
shook124920162sho_ok
shool84523152sho_ol
shools94919012shools
shoon84022012sho_on
shoos84226362sho_os
shoot84235912sho_ot
slalom888172slalom
sodom8814912s_odom
solo45538942s_olo_
solon55026132s_olon
solos54830792s_olos
solum74717612s_olum
stolon64112072stolon
tholoi9339232tholoi
tholos94213002tholos
whilom1436132whilom
abloom1039783abloom
ahold94714253ahol_d
aholds10469483aholds
apolog938903apolog
bhoot104322103bho_ot
bloom95918973blo_om
bolo65535953_bolo_
bolos75531373_bolos
boom87435673_bo_om
bosom95516923_bosom
broom95022213bro_om
celom9515693_celom
chalot113020133chalot
chola104718033chol_a
cholas114818003cholas
choler113717153choler
cholla113911023cholla
chook146015043cho_ok
coelom10310433coelom
colog86619933_colog
colon78630193_colon
color76123743_color
dhole95215363dhol_e
dholes104914793dholes
dhooly13457143dhooly
dolor67617963_dolor
doom76430073_do_om
duolog835803duolog
glom75424383__glom
gloom87116523glo_om
golem8416113_golem
groom85317983gro_om
halm95834973_hal_m
halo76437323_halo_
halon86124863_halon
halos85230253_halos
helm95530023_hel_m
helo75332853_helo_
helos84928063_helos
helot85332683_helot
hilum105514603_hilum
hobo97026083_hobo_
hobos106321353_hobos
hokum1436773_hokum
hold86235063_hol_d
holds94623243_holds
hole77553393_hol_e
holed95634133_holed
holes84748653_holes
holey115626903_holey
holism113713753_holism
holk116027943_hol_k
holks124720563_holks
holla84918493_holla
hollo84822163_hollo
holloa94914823_holloa
holloo94415253_holloo
hollos95320633_hollos
hollow124212663_hollow
holly114824433_holly
holms105117803_holms
holp95727553_hol_p
hols76946293_hol_s
holt77852583_hol_t
holts85627913_holts
holy106333433_hol_y
homo96126473_homo_
homos105921793_homos
honor85718623_honor
hood85132333_ho_od
hoof106036583_ho_of
hook116133283_ho_ok
hooly115022223_hooly
hoop96129983_ho_op
hoot75752103_ho_ot
isolog737403isolog
khoum1476643kho_um
kolo87026223_kolo_
kolos94921213_kolos
loom67035053_lo_om
nolo46229313_nolo_
nolos54423353_nolos
ovolo8339173ovolo_
ovolos9257203ovolos
phenom1339473phenom
phloem1335713phloem
phlox1737333ph_lox
phono104917023phono_
phonon114012033phonon
phonos114114793phonos
photo104417233photo_
photog12379813photog
photon1111514833photon
photos113316643photos
phylon14318033phylon
phylum1655153phylum
polo66236633_polo_
polos76129913_polos
prolog94212973prolog
room66235083_ro_om
sailor63113753sailor
sallow94315753sallow
salol55222143s_alol
salon55228553s_alon
saloon64418023saloon
saloop84212583saloop
sawlog1035793sawlog
scholar1236953scholar
scholia1237833scholia
scholium1545643scholium
school11410723scho_ol
schools1249113schools
scold85414863scol_d
scolds95011233scolds
scolex1538243scolex
scolioma1243383scolioma
scollop11275433scollop
scoop95617163sco_op
scoot75729153sco_ot
scotoma1155963scotoma
seldom939413seldom
shadow1337253shadow
shahdom1643973shahdom
shako125516093shako_
shakos134912193shakos
shale85332833shal_e
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shall85024053shal_l
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shalt85534493shal_t
shaly114322863shal_y
sham96436363sh__am
shamos114216983shamos
shamoy14379913shamoy
shawm135316153sh_awm
shazam2046623shazam
shelf115221113shel_f
shell84424123shel_l
shells94319523shells
shelly124414473shelly
shelta93111793shelta
shelty124011553shelty
shelve124012763shelve
shelvy15377863shelvy
sheol84318373sh_eol
sheols94614163sheol_s
shill85325333shil_l
shills94519613shills
shily115222013shil_y
shim95827863sh__im
shlep104914833sh_lep
shlock15378193shlock
shlub105411743sh_lub
shlump1345713sh_lump
shmo95318103sh_mo_
shnook1366343shnook
shoal83920273sho_al
shoaled113810973shoaled
shoaler102610083shoaler
shoals94215793shoals
shoaly124010773shoaly
shoat85633953sho_at
shoats94117083shoats
shock144917033sho_ck
shocks154414583shocks
shod86225063sh__od
shoddy1434543shoddy
shoe75933443sh__oe
shoebox1943623shoebox
shoed95723013sho_ed
shoer84722163sho_er
shoers94518333shoers
shoes85429663sho_es
shofar1236313shofar
shog86025143sh__og
shogi95014013sho_gi
shogis103810943shogis
shogs95319713sho_gs
shogun1045713shogun
shoji15419963sho_ji
shojis16348493shojis
shone83725983sho_ne
shooed103916083shooed
shooks134515633shooks
shooled115212663shooled
shoots94619363shoots
shop95629843sh__op
shopboy1743803shopboy
shoppe133110323shoppe
shops104222903sho_ps
shoran94016043shoran
shore85432653sho_re
shored105723653shored
shores94830413shores
shorl84720253sho_rl
shorls94516203shorls
shorn85722183sho_rn
short85040533sho_rt
shorts95321743shorts
shorty124313203shorty
shot76150263sh__ot
shote85526103sho_te
shotes95321913shotes
shots84730853sho_ts
shott85332193sho_tt
shotts93614703shotts
should1038033should
shout85433173sho_ut
shouts94017723shouts
shove114421043sho_ve
shoved134214283shoved
shovel124611323shovel
shover124515993shover
shoves124919423shoves
show106229193sh__ow
showed135016973showed
shower124315113shower
shown115216483sho_wn
showoff1943893showoff
showroom1654063showroom
shows115324583sho_ws
showy145714013sho_wy
shoyu1138913sho_yu
shoyus1266003shoyus
shul75823153shul__
shuln84713113shul_n
shuls85319713shul_s
shylock1945053shylock
shyly144811573shyl_y
sigloi737743sigloi
siglos7311473siglos
siglum936563siglum
silo46037913s_ilo_
silos56029433s_ilos
simoom1037503simoom
sitcom1036903sitcom
skelm114211293skel_m
slaloms9106543slaloms
slam67737973s__lam
slim66631963s__lim
slob66029423s__lob
sloe45534953s__loe
slog56728273s__log
sloop76118913slo_op
slop66533873s__lop
slot46049833s__lot
slow77729493s__low
slum65430513s__lum
smolt74824163smol_t
smolts84411883smolts
snood64616163sno_od
snook95115573sno_ok
snool55118643sno_ol
snools65715883snools
snoop75317173sno_op
snoot55030143sno_ot
sodoms989673s_odoms
sodomy1276673s_odomy
sokol94612293s_okol
sol37256623s_ol__
sola45541863s_ol_a
solan55328153s_olan
solar55927343s_olar
sold54837413s_ol_d
soldi65717203s_oldi
soldo67116563s_oldo
sole46053673s_ol_e
soled65835173s_oled
solei55624343s_olei
solemn838643s_olemn
soles55547923s_oles
soli46637013s_ol_i
solid65025083s_olid
solion6616383s_olion
soloed74515743s_oloed
solons65120023s_olons
sols45448163s_ol_s
solums85211333s_olums
solus54726983s_olus
solve85618943s_olve
som59153813s___om
sook84933393s_o_ok
soon46240503s_o_on
soot45761063s_o_ot
sopor74016493s_opor
sotol54917653s_otol
spoof105019013spo_of
spook115416043spo_ok
spool75219043spo_ol
spools85115913spools
spoon74719443spo_on
spoor75016353spo_or
stole54928813stol_e
stoled74521593stoled
stolen64315063stolen
stoles63927673stoles
stolid74213183stolid
stolons73410243stolons
stood65517713sto_od
stook95218213sto_ok
stool55619893sto_ol
stools65117023stools
stoop75821543sto_op
storm76520403sto_rm
sublot82315523sublot
swoon85014783swo_on
swoop105213433swo_op
syncom1336093syncom
theolog1146153theolog
thole85620843thol_e
tholed105113873tholed
tholes94919783tholes
thoro86217873thoro_
thoron94713903thoron
toom66532933_to_om
vroom105312473vro_om
whelm134611983whel_m
whole114418093whol_e
wholes124616773wholes
wholism1535883wholism
wholly15366573wholly
whom127018183wh__om
whoof144612693who_of
whoop134211443who_op
whoso11509223whoso_
zoom156722103_zo_om

Search took 6 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.420425454.8
2DLD Change Limit1127163545.33021147.5
3Display Results3543540.1103218.2
 (SQL Overall)1786913545.86030493.3
 
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.