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

147 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
samechs1428535(None) 
samech13277031samech_
samekhs16303921samekhs
lamedhs13444702lamedhs
samekh15355132samekh_
sameks12409322same_ks
sauchs115112232sa_uchs
sumachs14457352sumachs
alecs76620733_alec_s
alephs1136533_alephs
almehs11619493alme_hs
amahs107819063_am_ahs
amebas10311453_amebas
ameers84015573_ameers
amends94713283_amends
amens75624843_ame_ns
aments85219803_aments
amerces1149853_amerces
amices105018013_amices
amicus103810003_amicus
amucks1466003_amucks
arecas84817443_arecas
aspects1146743aspects
caleche14297953caleche
caleches15269943caleches
camels105217083came_ls
cameos105818003came_os
cameras11313363cameras
cames97047313came__s
catechu1444473catechu
catechus1544823catechus
daledhs1232783daledhs
daleths1135323daleths
dames85435853dame__s
faeces114713123fa_eces
fames105735923fame__s
gamers94420833game_rs
games86238553game__s
gametes10312253gametes
hames106138703hame__s
hamzahs24134373hamzahs
kames115024693kame__s
laichs115110893la_ichs
lamedh12476363lamedh_
lameds94812033lame_ds
laments94314853laments
lames75445543lame__s
machs125722563__machs
mameyes14376983mameyes
mameys13449523mame_ys
meths105320233__meths
namers84517333name_rs
names74833363name__s
pechs125516203__pechs
ramees84620893rame_es
ramets83517393rame_ts
sabers85224733sabe_rs
sabes76437463sabe__s
sacks114228873sa__cks
sacs65739073sa__c_s
sades65239893sade__s
safes85226723safe__s
sages65339063sage__s
saices84221803sa_ices
sakers104125433sake_rs
sakes95540753sake__s
saleps85014903sale_ps
sales56055593sale__s
samadhi1344063samadhi
samadhis1444253samadhis
samaras9312913samaras
sambals115213483sambals
sambars115113843sambars
sambas104219263sam_bas
sambos104315193sam_bos
sambucas1444163sambucas
samburs11369343samburs
same65245643same___
samek114915273same__k
sameness102712683sameness
samiels939763samiels
samites93118713samites
samlets93813553samlets
samosas939293samosas
sampans112411003sampans
samples112815453samples
samps96124673sam__ps
samshu11134623sam_shu
samshus12125353samshus
sanes55649073sane__s
sanghs105312063sa_nghs
sarees65329943sare_es
sarments10311963sarments
sateens73710753sateens
sates54949323sate__s
saucers93712133saucers
sauces84919503sa_uces
sauch104918773sa_uch_
saughs104812053sa_ughs
savers93825923save_rs
saves85838633save__s
sawers94620163sawe_rs
saxes125229343saxe__s
sayeds10469253saye_ds
sayers94221593saye_rs
seamers94719433seame_rs
secs65033893s__ec_s
sects75622893s__ects
selects91912143selects
sememes11109203sememes
semens84616973seme_ns
semes75731583seme__s
senecas939013senecas
shames114726223shame__s
sheuchs15234933sheuchs
shmears1277073shmears
shmucks1833943shmucks
siameses1036403siameses
smacks144112323s_macks
smears84714433s_mears
smeeks12428433s_meeks
smells83914743s_mells
smelts85412773s_melts
smerks12449713s_merks
smews104612293s_me_ws
smiths114711023s_miths
smocks145710013s_mocks
snecks124410033s_necks
specks144312703s_pecks
specs96916673s_pec_s
speech1347563speech_
speeches1537413speeches
stamens93411483stame_ns
stichs114511653s_tichs
stomachs1544953stomachs
subecho1445073subecho
sumach135310113sumach_
sumacs105512103sumac_s
synchs14408453s_ynchs
tachs105820933ta__chs
tameins9311423tameins
tamers84224033tame_rs
tames75242013tame__s
techs106915833__techs
wames106432803wame__s
yamens114010823yame_ns
yechs136112583__yechs

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.406440125.6
2DLD Change Limit1340271476.73619897.1
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.18824859.6
 
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.