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

145 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
samshu1113462(None) 
samshus12125351samshus
saddhu1133412saddhu
sadhu9459962sa_dhu
sambhur1453082sambhur
sash77235302sa_sh_
smash104814432smash_
smashup1443452smashup
amah98927493_amah_
amahs107819063_amahs
amu58237323_am__u
ash67944603_a_sh_
ashy107717353_a_shy
bams87044453bams__
bash915240163ba_sh_
cams87047283cams__
cash96636283ca_sh_
dams77444373dams__
damsel9148033damsel
damson938063damson
dash87031633da_sh_
dashi95013113da_shi
dashy125612383da_shy
famish14311853famish_
fash107232293fa_sh_
gams76648883gams__
gash86833023ga_sh_
hams96446133hams__
harsh116418053harsh_
hash106936503ha_sh_
jams135231073jams__
kamsin1238323kamsin
kasha124710723ka_sha
lams66552263lams__
lash76539653la_sh_
marsh105320853marsh_
marshy14558333marshy
mash96039403ma_sh_
mashy136016503ma_shy
pams85641763pams__
pash95638133pa_sh_
pasha105417183pa_sha
rams65950773rams__
ramson8310463ramson
rash76039933ra_sh_
sabs66643743sabs__
sacs65739073sacs__
saddhus1243673saddhus
sadhe94815133sa_dhe
sadhus10298463sa_dhus
sags55948403sags__
saith85826553saith_
saithe94713913saithe
sajou12311693sa_jou
sals46851673sals__
salsa56718923sals_a
salsas65316133salsas
samadhi1344063samadhi
samara8313853samara
samba95618773sam_ba
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sambhar1444853sambhar
sambhurs1543183sambhurs
sambo95118013sam_bo
sambos104315193sambos
sambur10469503sambur
same65245643sam__e
samech13277033samech
samechs14285353samechs
samek114915273sam_ek
samekh15355133samekh
samekhs16303923samekhs
sameks12409323sameks
samiel8313333samiel
samisen937673samisen
samite83020603samite
samlet84126563samlet
samosa8510203samosa
samosas939303samosas
samp85733593sam__p
sampan102511893sampan
sample104215013sample
samps96124673sam_ps
samsara936913samsara
sandhi1038193sandhi
sangh95517463sangh_
sanghs105312073sanghs
sans45153363sans__
sansar63613403sansar
sansei63411903sansei
saps65346373saps__
sarsar63011853sarsar
sarsen6314233sarsen
sashay1238363sa_shay
sashed105622943sa_shed
sashes94728483sa_shes
sasin54626573sa_sin
sass45035623sa_s_s
sassed76116173sassed
sasses64124393sasses
sassy85813813sa_ssy
sau36356573sa___u
sauch104918773sauch_
sauchs115112233sauchs
saugh95318403saugh_
saughs104812053saughs
saughy13507463saughy
saws75839483saws__
says75942103says__
sayst85322003says_t
scams94423973scams__
seams75731663seams__
shams105829413shams__
shush113812543shush_
sims65737183sims__
skosh12407273skosh_
slams74927903slams__
slash84719683slash_
slosh84514483slosh_
sloshy12366623sloshy
slush85316573slush_
slushy12417223slushy
smashed133711223smashed
smasher123911023smasher
smashes123914613smashes
smashups1543213smashups
smush104410583smush_
snash84815673snash_
soms66239373soms__
spams94922193spams__
stash84916973stash_
sums65837583sums__
sushi8310493s_ushi
swash116316753swash_
swish115114823swish_
swishy15365843swishy
tamasha12125433tamasha
tams67247933tams__
wash106033813wa_sh_
washup1435323wa_shup
washy145911843wa_shy
wushu1136993_wushu
yams95330733yams__

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.373479064.3
2DLD Change Limit1127161455.18621734.7
3Display Results1451450.0463152.2
 (SQL Overall)1786911455.60531880.6
 
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.