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 “meths” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
meths10532023(None) 
beths105519221beths
eths76619521_eths
heths116317781heths
maths105624021maths
metes74736211metes
meth95827841meth_
metis75025901metis
moths106021551moths
myths135911601myths
teths85418511teths
baths105922922baths
berths114712422berths
betas75528762betas
beth96629232beth_
bets67051442bet_s
cetes75731102cetes
cheths14389822cheths
deaths105914442deaths
depths12428572depths
edhs86212102_edhs
etas46432272_etas
eth66630982_eth_
ethos85514192_ethos
fehs106522382fe_hs
fetas85624402fetas
fetes85630142fetes
fets75345942fet_s
fetus85816542fetus
getas65421482getas
gets55442482get_s
goths96513002goths
heaths126316382heaths
hehs106723962he_hs
heth107028022heth_
hets75547202het_s
jetes124922842jetes
jets115834102jet_s
kheths16495972kheths
kiths125814972kiths
laths86022402laths
lethe85717302lethe
lethes94818082lethes
lets47147942let_s
machs125722562machs
mates75251362mates
math95437442math_
mats65460282mat_s
matts76829182matts
meads85425322meads
meals75933372meals
means75831222means
meats75034052meats
meatus85112922meatus
meds75735362me_ds
meeds84920272meeds
meets74224612meets
megs75530632me_gs
melds84822382melds
mells75031332mells
mels65941532me_ls
melts74930102melts
memes94927702memes
memos95719112memos
mems85931502me_ms
mends84927692mends
mensh105413552mensh
menus75822842menus
meous76120062meous
meows104612682meows
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
mesas76823202mesas
mesh96823002mesh_
meshes115019442meshes
meshy135612782meshy
mess65932432me_ss
met56072432met__
meta65932412met_a
metal75427382metal
metals84520882metals
mete64438132met_e
meted85424432meted
meter75130322meter
meters85625832meters
method1239022method
methods1338882methods
methyl1436402methyl
methyls1535452methyls
metol75917812metol
metols84115772metols
metre74821302metre
metres85121562metres
metro74718802metro
metros84217802metros
mewls105813232mewls
mews96629332me_ws
mezes167719262mezes
mirths114912992mirths
mites75141802mites
mitis75425992mitis
mitts75523752mitts
months113812932months
motes75944002motes
moth96731332moth_
mothy136214552mothy
mots66853162mot_s
motts76527002motts
mouths115214532mouths
musths11589482musths
mutes75033782mutes
muts64839982mut_s
mutts75120252mutts
myth126715432myth_
mythos14398462mythos
mythy16568672mythy
nets45941532net_s
netts55320722netts
oaths86117312oaths
paths105521382paths
pechs125516202pechs
pehs95625762pe_hs
pets66248332pet_s
piths105817542piths
rets45352562ret_s
ruths85714642ruths
sets45549502set_s
setts55124322setts
smiths114711022smiths
soths86218622soths
techs106915832techs
tenths94412662tenths
teth76327882teth_
tets45847452tet_s
vets76835092vet_s
wets75940292wet_s
yeahs115214552yeahs
yechs136112582yechs
yetis85418392yetis
yetts86715132yetts
zetas145018162zetas

Search took 5 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 Filter178691538000.186960704.3
2DLD Change Limit538001433.75014346.7
3Display Results1431430.0801787.5
 (SQL Overall)1786911434.01644494.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.