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

164 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
eths7661952(None) 
beths105519221beths
edhs86212101edhs
etas46432271etas
eth66630981eth_
ethos85514191ethos
heths116317781heths
meths105320231meths
teths85418511teths
aahs716428562aahs
ahs68644822_ahs
ates45047922ates
baths105922922baths
berths114712422berths
betas75528762betas
beth96629232beth_
bets67051442bet_s
cetes75731102cetes
cheths14389822cheths
dahs88231812dahs
deaths105914442deaths
depths12428572depths
ears46356592ears
earths95014592earths
eath75735662eath_
eats47054872eats
ebbs82411992ebbs
eche97520282eche
eches106322162eches
echo96615952echo
echos105216462echos
echt95722902echt
ecus65421462ecus
edh76921562edh_
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
eggs66516152eggs
egis56520652egis
egos55821652egos
eh58339962e_h_
ekes86726602ekes
elds56324852elds
elhi7612402elhi
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epha9310052epha
ephas10311542ephas
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
et26964192et__
eta35834192et_a
etch95419142etch
etches114217762etches
ether84518772ether
ethers94518412ethers
ethic101511222ethic
ethics11169282ethics
ethnos947052ethnos
ethyl1136512ethyl
ethyls1235902ethyls
etic66123952etic
etna46415262etna
etnas54713932etnas
etui45416232etui
etuis54013132etuis
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
fehs106522382fehs
fetas85624402fetas
fetes85630142fetes
fets75345942fet_s
fetus85816542fetus
getas65421482getas
gets55442482get_s
goths96513002goths
hahs108333362hahs
heaths126316382heaths
hehs106723962hehs
heth107028022heth_
hets75547202het_s
ichs96214712ichs
its35538832it_s
jetes124922842jetes
jets115834102jet_s
kheths16495972kheths
kiths125814972kiths
laths86022402laths
lethe85717302lethe
lethes94818082lethes
lets47147942let_s
maths105624022maths
metes74736212metes
meth95827842meth_
metis75025902metis
moths106021552moths
myths135911602myths
nets45941532net_s
netts55320722netts
nth66320592nth_
oaths86117312oaths
ohs66232312_ohs
oohs75220692oohs
paths105521382paths
pechs125516202pechs
pehs95625762pehs
pets66248332pet_s
piths105817542piths
rets45352562ret_s
ruths85714642ruths
sets45549502set_s
setts55124322setts
soths86218622soths
tas38477102_tas
teas45851492teas
techs106915832techs
teds54932572teds
tees45353582tees
tegs56031492tegs
tels46841692tels
tens45647412tens
tenths94412662tenths
teth76327882teth_
tets45847452tets
tews76431642tews
the67436052_the
this76027382_this
tho67433962_tho
thus76721472_thus
thy97022912_thy
tis37056642_tis
ughs85410972ughs
utas45924952utas
utes45930882utes
uts35534372ut_s
vets76835092vet_s
wets75940292wet_s
yeahs115214552yeahs
yechs136112582yechs
yetis85418392yetis
yetts86715132yetts
zetas145018162zetas

Search took 2 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 Filter178691298720.0961861364.6
2DLD Change Limit298721640.87334217.6
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.015176050.2
 
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.