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

306 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
samech1327703(None) 
samechs14285351samechs
samekh15355131samekh
lamedh12476362lamedh
same65245642same__
samek114915272same_k
samekhs16303922samekhs
sameks12409322sameks
sauch104918772sa_uch
speech1347562speech
sumach135310112sumach
aitch105216163_aitch
alec66430063_alec_
alecs76620733_alecs
aleph10311393_aleph
almeh106214553alme_h
amah98927493_am_ah
ameba9312383_ameba
ameer75618983_ameer
amen66733153_ame_n
amend85717753_amend
amens75624843_amens
ament76036543_ament
amerce10310513_amerce
amice96122873_amice
amici94217393_amici
amuck1389563_amuck
arch98628443_a_rch
areca75618633_areca
aspect10612823aspect
bach116131393ba__ch
batch124620103ba_tch
beech124315503_beech
breech13348263breech
caeca93915133ca_eca
caleche14297953caleche
came87648753came__
camel96822803came_l
camels105217083camels
cameo95924993came_o
cameos105818003cameos
camera10313693camera
cames97047313came_s
caroch13911763caroch
catch125120373ca_tch
catechu1444473catechu
cometh134811683cometh
daledh1133743daledh
daleth1038633daleth
dame77140313dame__
dames85435853dame_s
each95530583ea__ch
enmesh1134893enmesh
fame95639393fame__
famed115928343fame_d
fames105735923fame_s
famish14311843famish
fleech14367343fleech
game76644323game__
gamed95126393game_d
gamely124711913gamely
gamer84928943game_r
gamers94420833gamers
games86238553game_s
gamest94919933gamest
gamete9313593gamete
gamey115320553game_y
gamic103916203gamic_
hame97043133hame__
hames106138703hame_s
hamzah23135563hamzah
hatch135719593ha_tch
haunch14377343haunch
immesh1334113immesh
inmesh1134863inmesh
kame105728233kame__
kames115024693kame_s
laich105920713la_ich
lame66849293lame__
lamed85235293lame_d
lamedhs13444703lamedhs
lameds94812033lameds
lamely114013223lamely
lament85024943lament
lamer75233703lame_r
lames75445543lame_s
lamest84722763lamest
larch105919793la_rch
latch104620463la_tch
launch11368063launch
lech96825443__lech
leech104913213_leech
mach116134483__mach
mamey125418833mame_y
mameys13449523mameys
march125622893ma_rch
match125621103ma_tch
merch125417963__merch
mesh96823003__mesh
meth95827843__meth
much115224033__much
name65637413name__
named85223063name_d
namely113711323namely
namer75622103name_r
namers84517333namers
names74833363name_s
natch105018223na_tch
nautch1144813nautch
painch133511323painch
parch125123003pa_rch
patch125221223pa_tch
paunch13369853paunch
pech116125453__pech
ramee74633853rame_e
ramees84620893ramees
ramen75625193rame_n
ramet75743143rame_t
ramets83517393ramets
ranch105019793ra_nch
ratch104221363ra_tch
raunch11358433raunch
sabe66140573sabe__
sabed86526813sabe_d
saber75330243sabe_r
sabers85224733sabers
sabes76437463sabe_s
sac57452863sa__c_
sack105337313sa__ck
sacs65739073sa__cs
sade55544473sade__
sades65239893sade_s
sae38365183sa_e__
safe75930953safe__
safely12249393safely
safer84721813safe_r
safes85226723safe_s
safest95016603safest
safety12206913safety
sage55044593sage__
sagely102811383sagely
sager65432053sage_r
sages65339063sage_s
sagest74920263sagest
saice75424053sa_ice
saices84221803saices
saith85826553sa_ith
sake85244963sake__
saker95132023sake_r
sakers104125433sakers
sakes95540753sake_s
sale44959703sale__
salep77022953sale_p
saleps85014903saleps
sales56055593sale_s
salic73424713salic_
samadhi1344063samadhi
samara8313853samara
samba95618773sam_ba
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sambo95118013sam_bo
sambos104315193sambos
sambuca1344343sambuca
sambur10469503sambur
samiel8313333samiel
samiels939763samiels
samite83020603samite
samlet84126563samlet
samlets93813553samlets
samosa8510203samosa
samp85733593sam__p
sampan102511893sampan
sample104215013sample
samps96124673sam_ps
samshu11134623samshu
sane45954343sane__
saned65636273sane_d
sanely93114613sanely
saner54334323sane_r
sanes55649073sane_s
sanest64426693sanest
sangh95517453sa_ngh
saree55044663sare_e
sarees65329943sarees
sarment9318763sarment
sash77235303sa__sh
sate45556103sate__
sated66238533sate_d
sateen63815013sateen
satem76021463sate_m
sates54949323sate_s
sauce75121653sa_uce
sauced93913303sauced
saucer84314103saucer
sauces84919503sauces
sauchs115112233sa_uchs
saucy104615163sa_ucy
saugh95318403sa_ugh
save75741363save__
saved95127113save_d
saver84831253save_r
savers93825923savers
saves85838633save_s
sawed95628403sawe_d
sawer85026213sawe_r
sawers94620163sawers
saxes125229343saxe_s
sayed96127143saye_d
sayeds10469253sayeds
sayer84926553saye_r
sayers94221593sayers
sayest94217743sayest
scooch13228123scooch
scorch13198093scorch
scotch13207523scotch
screech1435223screech
sculch13226213sculch
scutch13247083scutch
seabeach1543663seabeach
seamed94823883seame_d
seamen84518563seame_n
seamer84223613seame_r
seamers94719433seamers
search113312423search
sec55945323s__ec_
secs65033893s__ecs
sect67443623s__ect
select82621173select
seme65836653seme__
sememe10129983sememe
semen75724103seme_n
semens84616973semens
semes75731583seme_s
seneca839793seneca
shame105726703shame__
shamed125120213shame_d
shames114726223shame_s
sheesh1237813sheesh
sheuch14267043sheuch
shmear1176933shmear
shmuck1734243shmuck
siamese936503siamese
sketch1535363sketch
slatch114510533slatch
slouch11438523slouch
smack134615453s_mack
smash104814433s_mash
smear74416393s_mear
smeek114912353s_meek
smell74916233s_mell
smelt74726783s_melt
smerk115412723s_merk
smew95017733s_me_w
smews104612293s_mews
smirch1356463smirch
smith107818053s_mith
smock135311673s_mock
smooch13266803smooch
smush104410583s_mush
smutch13205843smutch
snatch114310603snatch
sneck114713663s_neck
sneesh945893sneesh
snitch11357943snitch
some66040383some__
spec85821973s_pec_
speck135115653s_peck
specs96916673s_pecs
squelch2152953squelch
stamen84115943stame_n
stamens93411483stamens
stanch113812373stanch
starch113013203starch
staunch1244273staunch
stench114111163stench
stich104117923s_tich
stitch11419103stitch
stomach1436033stomach
stretch1236413stretch
subecho1445073subecho
such96424813s__uch
sumac99514883sumac_
sumachs14457353sumachs
sumacs105512103sumacs
swatch14549283swatch
switch14458913switch
synch135011793s_ynch
tach96132753ta__ch
tame66343663tame__
tamed85528513tame_d
tamein8313093tamein
tamely113711953tamely
tamer75230103tame_r
tamers84224033tamers
tames75242013tame_s
tamest85721293tamest
tech95925443__tech
unmesh1145793unmesh
wame95035483wame__
wames106432803wame_s
watch135617063wa_tch
yamen104115183yame_n
yamens114010823yamens
yech127220533__yech

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.420425454.8
2DLD Change Limit1127163066.23618075.0
3Display Results3063060.0933290.3
 (SQL Overall)1786913066.74926476.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.