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

243 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
sumach13531011(None) 
sumac99514881sumac_
sumachs14457351sumachs
sumacs105512101sumacs
mach116134482__mach
samech13277032samech
smack134615452s_mack
smash104814432s_mash
smutch13205842smutch
stomach1436032stomach
subah106015212suba_h
succah1336642succah
such96424812su__ch
surah86823252sura_h
almah106917263alma_h
amah98927503_ama_h
attach11118393attach
autarch1246623autarch
bach116131393__bach
beach124623893_beach
bimah127013273bima_h
bleach133611403bleach
brach126123303_brach
breach134213723breach
broach133611113broach
bumph144911983bum_ph
bunch125118603bu_nch
butch125416543bu_tch
clach124617823_clach
coach125919453_coach
culch124512833cu_lch
cultch13385953cultch
curacy1339593curacy
curagh1236553curagh
curch124415413cu_rch
currach1446453currach
cutch125116193cu_tch
detach12310413detach
duma75524453duma__
dumas85420433duma_s
dunch115316263du_nch
dutch114713823du_tch
each95530583__each
eunuch1154363eunuch
guaco85012163gu_aco
gulch113810603gu_lch
human102716033huma_n
humane112812173humane
humans112312433humans
humate113214443humate
humic124113243humic_
humph155712213hum_ph
hunch136416213hu_nch
hutch135414093hu_tch
isopach1444243isopach
isotach1244953isotach
leach105422523_leach
loach105116363_loach
luma65527523luma__
lumas75622913luma_s
lunacy1136843lunacy
lunch104917243lu_nch
lurch104814633lu_rch
mac78053933__mac_
mace87345793__mace
mache125925303__mache
macho126120153__macho
machs125722563__machs
mack125733653__mack
macs86742513__macs
march125622893__march
mash96039403__mash
match125621103__match
math95437453__math
much115224033__much
mulch124012973mu_lch
munch124917103mu_nch
mutch125016173mu_tch
naumachy1841833naumachy
nomarch1445353nomarch
orach105219233_orach
ouch95724633ou__ch
outact8317203outact
outmarch1544793outmarch
outmatch1544173outmatch
peach125422493_peach
pleach134211243pleach
poach124917863_poach
pomace123111913pomace
preach133613923preach
pujah17478543puja_h
puma85424123puma__
pumas95121563puma_s
pumice1238223pumice
punch125118423pu_nch
putsch1334933putsch
quack203812503qu_ack
quaich2047693quaich
quamash2144293quamash
quash174512163qu_ash
quench2036633quench
quitch2036413quitch
reach105123883_reach
rematch1436193rematch
roach105717003_roach
rubace10310173rubace
rumaki1235133rumaki
sac57452863s__ac_
sack105337313s__ack
sacs65739073s__acs
samadhi1344063samadhi
samara8313853samara
samechs14285353samechs
samekh15355133samekh
sash77235303s__ash
sauch104918773s_auch
scooch13228123scooch
scorch13198093scorch
scotch13207523scotch
scraich1436763scraich
scratch1446013scratch
sculch13226213sculch
scultch1483543scultch
scutch13247083scutch
search113312423search
selah8319613sela_h
serac75925203serac_
seracs84418573seracs
seraph114011163seraph
sfumato1253683sfumato
shack145321753s_hack
shah105627783s_ha_h
sheath12412893sheath
sheuch14267043sheuch
shmuck1734243shmuck
sima64730793sima__
simar74920813sima_r
simars84916933simars
simas75727553sima_s
sketch1535363sketch
slack115021763s_lack
slash84719683s_lash
slatch114510533slatch
slouch11438523slouch
smacks144112323s_macks
small74016263s_mall
smalt74729333s_malt
smarm95517603s_marm
smart75834093s_mart
smaze165012933s_maze
smirch1356463smirch
smith107818053s_mith
smock135311673s_mock
smooch13266803smooch
smush104410583s_mush
smutchy17193153smutchy
snack114718063s_nack
snash84815673s_nash
snatch114310603snatch
snath86419803s_nath
snitch11357943snitch
solace83415823solace
soma65635293soma__
soman75024903soma_n
somans84619303somans
somas76030373soma_s
somata8312383somata
soutache1344983soutache
space95325673s_pace
spacy125415623s_pacy
speech1347563speech
spinach1435403spinach
splash1168823splash
squash1846833squash
squelch2152953squelch
squinch2134833squinch
stack114421693s_tack
stanch113812373stanch
staph104314653s_taph
starch113013203starch
stash84916973s_tash
stench114111163stench
stich104117923s_tich
stitch11419103stitch
stomachs1544953stomachs
stomachy1843823stomachy
strath93216373strath
suave83519873su_ave
suba64926603suba__
subacid1248473subacid
subahs114512393subahs
subas74724083suba_s
subecho1445073subecho
subrace11313003subrace
succahs1435333succahs
suck106131733su__ck
sudary1038703sudary
sugar6312913suga_r
sugars7312423sugars
sugary1039013sugary
sugh86423443su__gh
sukkah12123733sukkah
sulcal8311283sulcal
sulci7615053su_lci
sum56346013sum___
summa94713313sum_ma
summae103911013summae
summand1236263summand
summary14297353summary
summas104313163summas
summate113611663summate
summed114014043summed
summer104017713summer
summit10311543summit
summon1037623summon
sumo67326313sum__o
sumos75720093sum_os
sump86331533sum__p
sumps95023433sum_ps
sums65837583sum__s
sunback1548153sunback
sunbath1236423sunbath
sunnah9369353sunnah
sura45740293sura__
surahs94515543surahs
sural55931263sura_l
suras55336333sura_s
surface1238653surface
swash116316753s_wash
swatch14549283swatch
swath115920383s_wath
switch14458913switch
synch135011793s_ynch
tach96132753__tach
teach105221123_teach
turaco839453turaco
umami939883_umami
umiac938963_umiac_
umiack1435173_umiack
umiacs1035663_umiacs
unmacho1443923unmacho
yucch15417433yu_cch
yuch125818533yu__ch

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.376475242.0
2DLD Change Limit1127162436.45317467.2
3Display Results2432430.0763197.4
 (SQL Overall)1786912436.90525878.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.