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

443 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
shalom1181092(None) 
shaloms1288981shaloms
sholom11910111sholom
slalom888171slalom
chalot113020132chalot
halm95834972_hal_m
halo76437322_halo_
halon86124862_halon
halos85230252_halos
salol55222142s_alol
salon55228552s_alon
shadow1337252shadow
shahdom1643972shahdom
shako125516092shako_
shakos134912192shakos
shale85332832shal_e
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shal_l
shallop12348452shallop
shallot103614132shallot
shallow13388872shallow
shalt85534492shal_t
shaly114322862shal_y
sham96436362sha__m
shamos114216982shamos
shamoy14379912shamoy
shawm135316152sha_wm
shazam2046622shazam
sholoms1278032sholoms
slaloms9106542slaloms
whilom1436132whilom
aloe45540193__aloe
alow75328593__alow
alum65227613__alum
analog7159973analog
atom67824523__atom
baalim1038473baalim
balm85534203_bal_m
calm85032363_cal_m
calo64936443_calo_
calos74431903_calos
carom95025563_carom
celom9515693_celom
chador1238673chador
chalah143511663chalah
chaleh143711993chaleh
chalet113825993chalet
chalk144814603chal_k
chalks155412143chalks
chalky18468773chalky
challa114014193challa
challot123613263challot
chally144314293chally
chalone12312103chalone
chaloth15298603chaloth
cham115532313cha__m
chao95727313cha_o_
chaos105622863cha_os
charm126124663cha_rm
chasm125518793cha_sm
cholo105217973cholo_
cholos114716853cholos
coelom10310433coelom
dhal86719283dhal__
dhals95415443dhal_s
dialog837973dialog
diatom939453diatom
enhalo987563enhalo_
enhalos1087533enhalos
escalop1144783escalop
eschalot1346223eschalot
etalon648973etalon
galop84716223_galop
glom75424383__glom
haem95730983_ha_em
hakim14311833_hakim
halal85623593_halal
hale76052833_hal_e
haled95335823_haled
haler85033523_haler
hales85449843_hales
half106238453_hal_f
halid94424983_halid
halidom1386443_halidom
hall75741163_hal_l
hallo85127553_hallo
halloa94918123_halloa
halloo95118973_halloo
hallos95425103_hallos
hallot95426783_hallot
hallow124818323_hallow
halls85633783_halls
halma108219253_halma
halms105225213_halms
haloed104717603_haloed
haloes94623863_haloes
haloid104317763_haloid
halons95720713_halons
halt76056303_hal_t
halts85230103_halts
halva115414433_halva
halve114818923_halve
ham86363283_ha__m
hansom11219153_hansom
hao67251123_ha_o_
haole84820083_haole
harem104924453_harem
harlot94422803_harlot
harm95637793_ha_rm
haulm104415413_haulm
havoc1337183_havoc
helm95530023_hel_m
helo75332853_helo_
helos84928063_helos
helot85332683_helot
hilum105514603_hilum
holm95628113_hol_m
jalop144212603_jalop
kalam11315113_kalam
khalif1657833khalif
malm85129983_mal_m
mohalim1446033mohalim
palm85331363_pal_m
pashadom1643843pashadom
phalli1148263phalli
phantom1436693phantom
pharos11312063pharos
phenom1339473phenom
phloem1335713ph_loem
phlox1737333ph_lox
phylon14318033phylon
phylum1655153phylum
psalm949273psal_m
qualm163511183qual_m
realm75621623real_m
rhabdom1543383rhabdom
sabot7931783s_abot
sago56332673s_ago_
sagos66123873s_agos
sagum8512873s_agum
sailor63113753sailor
sajou12311693s_ajou
sal36462883s_al__
salaam8711013s_alaam
salad65321833s_alad
salal55425703s_alal
salami8313103s_alami
sale44959703s_al_e
salep77022953s_alep
sales56055593s_ales
salic73424713s_alic
sall44544683s_al_l
sallow94315753sallow
sally85129713s_ally
salmi7815863s_almi
salmon84614183s_almon
salols64017873s_alols
salons63823693s_alons
saloon64418023s_aloon
saloop84212583s_aloop
salp64534093s_al_p
salpa75018353s_alpa
salps74423243s_alps
sals46851673s_al_s
salsa56718923s_alsa
salt45758523s_al_t
salts55431883s_alts
salty85524383s_alty
salve85022133s_alve
salvo84415643s_alvo
salvor94711093s_alvor
salvos94613383s_alvos
sapor75119253s_apor
sarod65325873s_arod
saros55238063s_aros
satem76021463s_atem
savor85417943s_avor
savoy114713883s_avoy
sawlog1035793sawlog
scalar83612433scalar
scald84818123scal_d
scalds94813693scalds
scale74629143scal_e
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scall74420373scal_l
scallop11237643scallop
scalls84218203scalls
scalp95217983scal_p
scalps104315233scalps
scaly104718723scal_y
scam85932353sca__m
seadog838743seadog
seal45654373seal__
sealed74328363sealed
sealer63928963sealer
seals54839693seal_s
seam66645973sea__m
season62714903season
seldom939413seldom
sha69837783sha___
shabby1635803shabby
shack145321753sha_ck
shacko153810113shacko
shackos16429023shackos
shacks154817563shacks
shad86230913sha__d
shadblow1742313shadblow
shade95125583sha_de
shaded114518873shaded
shader104218763shader
shades105924533shades
shadoof1446133shadoof
shadows1437193shadows
shadowy1744723shadowy
shads95124483sha_ds
shaduf1337063shaduf
shady125416513sha_dy
shaft115725273sha_ft
shafts125411443shafts
shag86430563sha__g
shaggy14478043shaggy
shags95123863sha_gs
shah105627783sha__h
shahdoms1743773shahdoms
shahs115919513sha_hs
shaird10288703shaird
shairn9269063shairn
shake124726403sha_ke
shaken134113613shaken
shaker134319463shaker
shakes135024593shakes
shakoes144510023shakoes
shaky154616843sha_ky
shalier103116423shalier
shalloon1145683shalloon
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
shaman113314283shaman
shamas113717943shamas
shame105726703sha_me
shamed125120213shamed
shames114726223shames
shammos14307203shammos
shammy16388503shammy
shamois123210423shamois
shamosim1544753shamosim
shamoys15367283shamoys
shampoo1435373shampoo
shams105829413sha_ms
shamus114112813shamus
shandy134710033shandy
shank125422193sha_nk
shanks135315583shanks
shanny124110093shanny
shanti94014093shanti
shanty124715123shanty
shape105125113sha_pe
shaped125020103shaped
shapen114414653shapen
shaper114119933shaper
shapes115124953shapes
shard96125963sha_rd
shards104319173shards
share86437083sha_re
shared105829063shared
sharer95025483sharer
shares95236413shares
sharia93116733sharia
sharif122917123sharif
shark126225023sha_rk
sharks135019723sharks
sharn84823703sha_rn
sharns95516983sharns
sharny124711833sharny
sharp104922533sha_rp
sharps115516083sharps
sharpy145211033sharpy
shaslik1444513shaslik
shat76456603sha__t
shaugh13287433shaugh
shaul85418103sha_ul
shauled1148793shauled
shauls94913113shauls
shave114425893sha_ve
shaved135118383shaved
shaven124213303shaven
shaver123718913shaver
shaves125224933shaves
shavie124312423shavie
shaw108132553sha__w
shawed134817233shawed
shawl116217573sha_wl
shawled1437773shawled
shawls125411973shawls
shawms14579563shawms
shawn116417613sha_wn
shaws116226263sha_ws
shay107133343sha__y
shays116021433sha_ys
sheal84927703sheal__
sheals94420643sheal_s
shekalim1742533shekalim
shelf115221113shel_f
shell84424123shel_l
shells94319523shells
shelly124414473shelly
shelta93111793shelta
shelty124011553shelty
shelve124012763shelve
shelvy15377863shelvy
sheol84318373sh_eol
sheols94614163sheols
sheqalim2242303sheqalim
shill85325333shil_l
shills94519613shills
shily115222013shil_y
shim95827863sh__im
shlep104914833sh_lep
shlock15378193sh_lock
shlub105411743sh_lub
shlump1345713sh_lump
shmaltz2144653shmaltz
shmo95318103sh_mo_
shnook1366343shnook
shoal83920273shoal__
shoaled113810973shoaled
shoaler102610083shoaler
shoals94215793shoal_s
shoaly124010773shoal_y
shod86225063sh__od
shoe75933443sh__oe
shog86025143sh__og
shoo75929893sh__oo
shook124920163sh_ook
shool84523153sh_ool
shools94919013shools
shoon84022013sh_oon
shoos84226363sh_oos
shoot84235913sh_oot
shop95629843sh__op
shot76150263sh__ot
show106229193sh__ow
shul75823153shul__
shuln84713113shul_n
shuls85319713shul_s
shylock1945053shylock
shyly144811573shyl_y
sial45938833sial__
sialic8313633sialic
sialid7314943sialid
sialoid8310963sialoid
sials54227243sial_s
sigloi737743sigloi
siglos7311473siglos
siglum936563siglum
silo46037913s_ilo_
silos56029433s_ilos
simoom1037503simoom
sitcom1036903sitcom
skald104210173skal_d
skalds11437833skalds
skatol1035723skatol
skelm114211293skel_m
slalomed1134283slalomed
slalomer1045033slalomer
slam67737973s__lam
slim66631963s__lim
slob66029423s__lob
sloe45534953s__loe
slog56728273s__log
slop66533873s__lop
slot46049833s__lot
slow77729493s__low
slum65430513s__lum
small74016263smal_l
smalls84514123smalls
smalt74729333smal_t
smalti84111193smalti
smalto84410283smalto
smaltos9408193smaltos
smalts85214893smalts
smarm95517603sma_rm
sodom8814913s_odom
solo45538943s_olo_
solon55026133s_olon
solos54830793s_olos
solum74717613s_olum
som59153813s___om
spado83713703spado_
spale74929213spal_e
spales84728103spales
spall74919303spal_l
spalls84217343spalls
spam85930043spa__m
spasm94514173spa_sm
squalor1644423squalor
stalag7310023stalag
stale55637103stal_e
staled74728103staled
staler64025823staler
stales65538293stales
stalk94518003stal_k
stalks104614553stalks
stalky13499303stalky
stall54722353stal_l
stalls64019933stalls
stanol6310723stanol
stardom1037763stardom
stator64015483stator
stolon64112073stolon
subatom1147053subatom
sublot82315523sublot
swale85221593swal_e
swales93920763swales
swallow13355753swallow
swam96329983swa__m
swarm106218843swa_rm
syncom1336093syncom
talon55824113_talon
thairm1156963thairm
thalami1246083thalami
thaler94613103thaler
thalli958923thalli
tharm105916643tha_rm
tholoi9339233tholoi
tholos94213003tholos
thraldom1442813thraldom
valor83614893_valor
whale115517433whal_e
whaled134612033whaled
whaler124611973whaler
whales124716943whales
wham125321693wha__m
whammo16405193whammo
whamo135511263whamo_
whelm134611983whel_m
whom127018183wh__om
zealot15313473zealot

Search took 7 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.390458182.1
2DLD Change Limit1127164435.61020092.0
3Display Results4434430.1403164.3
 (SQL Overall)1786914436.14029102.8
 
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.