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

122 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
samekhs1630392(None) 
samechs14285351samechs
samekh15355131samekh_
sameks12409321samek_s
lamedhs13444702lamedhs
samech13277032samech_
samek114915272samek__
alephs1136533_alephs
almehs11619493alme_hs
amahs107819063_am_ahs
amebas10311453_amebas
ameers84015573_ameers
amends94713283_amends
amens75624843_ame_ns
aments85219803_aments
amoks11413553_amok_s
ankhs12116723_a_nkhs
camels105217083came_ls
cameos105818003came_os
cameras11313363cameras
cames97047313came__s
daledhs1232783daledhs
daleths1135323daleths
dames85435853dame__s
fames105735923fame__s
gamers94420833game_rs
games86238553game__s
gametes10312253gametes
haceks15447863hacek_s
hames106138703hame__s
hamzahs24134373hamzahs
kames115024693kame__s
kamiks11387913kamik_s
lakhs125210343la__khs
lamedh12476363lamedh_
lameds94812033lame_ds
laments94314853laments
lames75445543lame__s
mameyes14376983mameyes
mameys13449523mame_ys
meths105320233__meths
namers84517333name_rs
names74833363name__s
ramees84620893rame_es
ramekin13126493ramekin
ramekins1466113ramekins
ramets83517393rame_ts
sabers85224733sabe_rs
sabes76437463sabe__s
sackers133820223sackers
sacks114228873sa_ck_s
sades65239893sade__s
safes85226723safe__s
sages65339063sage__s
sakers104125433sake_rs
sakes95540753sa__kes
sakis95323673sa__kis
saleps85014903sale_ps
sales56055593sale__s
salukis1136033salukis
samadhi1344063samadhi
samadhis1444253samadhis
samaras9312913samaras
sambals115213483sambals
sambars115113843sambars
sambas104219263sam_bas
sambos104315193sam_bos
sambukes1644193sambukes
samburs11369343samburs
same65245643same___
sameness102712683sameness
samiels939763samiels
samites93118713samites
samlets93813553samlets
samosas939293samosas
sampans112411003sampans
samples112815453samples
samps96124673sam__ps
samshu11134623sam_shu
samshus12125353samshus
sanes55649073sane__s
sanghs105312063sa_nghs
sarees65329943sare_es
sarks96632463sa_rk_s
sarments10311963sarments
sateens73710753sateens
sates54949323sate__s
sauchs115112233sa_uchs
saughs104812053sa_ughs
savers93825923save_rs
saves85838633save__s
sawers94620163sawe_rs
saxes125229343saxe__s
sayeds10469253saye_ds
sayers94221593saye_rs
seamers94719433seame_rs
seeks94724643s_eek_s
sememes11109203sememes
semens84616963seme_ns
semes75731583seme__s
shames114726223shame__s
sheikhs17233993sheikhs
shmears1277073shmears
siameses1036403siameses
sleeks104512463sleek_s
smacks144112323smack_s
smears84714433s_mears
smeeks12428433s_meeks
smells83914743s_mells
smelts85412773s_melts
smerks12449713s_merks
smews104612293s_me_ws
smiths114711023s_miths
smokes124814343s_mokes
stamens93411483stame_ns
steeks103613703steek_s
sumachs14457353sumachs
tameins9311413tameins
tamers84224033tame_rs
tames75242013tame__s
wames106432803wame__s
yamens114010823yame_ns

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 Limit1340271227.07618941.1
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.52823736.8
 
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.