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

133 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
sumachs1445735(None) 
sumach135310111sumach_
sumacs105512101sumac_s
machs125722562__machs
samechs14285352samechs
smacks144112322s_macks
stomachs1544952stomachs
subahs114512382suba_hs
succahs1435322succahs
sumac99514882sumac__
surahs94515542sura_hs
almahs118611613alma_hs
amahs107819063_ama_hs
aurochs1245983aurochs
autarchs1344993autarchs
bimahs13508303bima_hs
brachs134415753_brachs
bumphs15467103bum_phs
clachs133511323_clachs
curaghs1334583curaghs
currachs1544543currachs
dumas85420433duma__s
eunuchs1272683eunuchs
guacos94410313gu_acos
humans112312433huma_ns
humates122813193humates
humphs16528163hum_phs
isopachs1543243isopachs
isotachs1343773isotachs
lumas75622913luma__s
maces97139963__maces
mach116134483__mach_
mache125925303__mache
maches134827233__maches
macho126120153__macho
machos135217493__machos
macks135127603__macks
macs86742513__mac_s
maths105624023__maths
naumachy1841833naumachy
nomarchs1543903nomarchs
outacts9310213outacts
pomaces132712123pomaces
pujahs18404943puja_hs
pumas95121563puma__s
pumices1338273pumices
quacks214710103qu_acks
quaichs2144633quaichs
rubaces1139313rubaces
rumakis1335533rumakis
sacks114228873s__acks
sacs65739073s__ac_s
samadhi1344063samadhi
samadhis1444253samadhis
samaras9312913samaras
samech13277033samech_
samekhs16303923samekhs
sauchs115112233s_auchs
scraichs1543993scraichs
selahs9313213sela_hs
seracs84418573serac_s
seraphs12408093seraphs
sfumatos1353343sfumatos
shacks154817563s_hacks
shahs115919513s_ha_hs
sheaths1358753sheaths
sheuchs15234933sheuchs
shmucks1833943shmucks
simars84916933sima_rs
simas75727553sima__s
slacks124416533s_lacks
smack134615453s_mac_k
smalls84514123s_malls
smalts85214893s_malts
smarms105712533s_marms
smarts86218003s_marts
smash104814433s_mash_
smashes123914613s_mashes
smazes174311663s_mazes
smiths114711023s_miths
smocks145710013s_mocks
smutch13205843smutch_
smutches15177273smutches
smutchy17193153smutchy
snacks124514553s_nacks
snaths95112913s_naths
solaces93116133solaces
somans84619303soma_ns
somas76030373soma__s
soutache1344983soutache
soutaches1446443soutaches
spaces104722633s_paces
stacks124317263s_tacks
staphs114411033s_taphs
stichs114511653s_tichs
stomach1436033stomach_
stomachy1843823stomachy
straths102711723straths
subacid1248473subacid
subah106015213suba_h_
subas74724073suba__s
subecho1445073subecho
subraces12313033subraces
succah1336643succah_
such96424813su__ch_
sucks114523073su__cks
sugars7312423suga_rs
sughs95313323su__ghs
sukkahs1382703sukkahs
sulcus8410493su_lcus
sumless92611123sumless
summands1344713summands
summas104313163sum_mas
summates122610493summates
summers113616503summers
summits1137983summits
summons1158003summons
sumos75720093sum__os
sumps95023433sum__ps
sums65837583sum___s
sunbaths1344383sunbaths
sunnahs10326593sunnahs
surah86823253sura_h_
suras55336333sura__s
surfaces1338673surfaces
swaths125312643s_waths
synchs14408453s_ynchs
tachs105820933__tachs
turacos938643turacos
umamis1038273_umamis
umiacks1534013_umiacks
umiacs1035663_umiac_s
unmacho1443923unmacho

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271336.70319995.1
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.14225019.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.