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

191 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
teth7632788(None) 
beth96629231beth
eth66630981_eth
heth107028021heth
meth95827841meth
tech95925441tech
teeth87315851teeth
tenth85421831tenth
tet39274981tet_
teths85418511teths
tets45847451tets
bath95940082bath
berth104917882berth
bet58376672bet_
beta66234132beta
beths105519222beths
bets67051442bets
both96533432both
cete64934782cete
cheth135013822cheth
death94822522death
depth114311852depth
doeth9411982doeth
doth86225712doth
eath75735662eath
edh76921562_edh
eh58339962_e_h
et26964192_et_
eta35834192_eta
etch95419142etch
eths76619522_eths
feh96136092fe_h
fet66471632fet_
feta76528902feta
fetch134913472fetch
fete75734922fete
fets75345942fets
get47467462get_
geta56627442geta
gets55442482gets
goth86825082goth
hath105933912hath
heath115724282heath
heh96039622he_h
het67674312het_
heths116317782heths
hets75547202hets
jet106754822jet_
jete115927252jete
jets115834102jets
ketch144912022ketch
keto86223452keto
kheth15509752kheth
kith115826352kith
lath76640382lath
lech96825442lech
let36481472let_
letch105215802letch
lethe85717302lethe
lets47147942lets
loth76132132loth
math95437442math
mesh96823002mesh
met56072432met_
meta65932412meta
mete64438132mete
meths105320232meths
moth96731332moth
myth126715432myth
neath86020282neath
net36670292net_
nets45941532nets
nett46643232nett
nth66320592_nth
oath76132152oath
path99134912path
pech116125452pech
peh86740962pe_h
pet56477302pet_
pets66248332pets
pith95432692pith
rath76037662rath
resh76523452resh
ret35982832ret_
retch104818302retch
rete44944132rete
rets45352562rets
ruth76825992ruth
set36681252set_
seta45637312seta
sets45549502sets
sett45949052sett
sith75435152sith
soth75932512soth
stet45947322stet_
stets55423912stets
tach96132752tach
tat37690292tat_
tate44748602tate
tats46858132tats
tea37353322te_a
teach105221122teach
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
teats55636812teats
techs106915832techs
techy135612012techy
tecta74215522tecta
ted46446562te_d
teds54932572teds
tee38366872te_e
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
teethe94511312teethe
teff106023762teff
teg45741622te_g
tegg65315922tegg
tegs56031492tegs
tel35647902te_l
tela45532972tela
tele45040872tele
tell44934702tell
tels46841692tels
temp85323332temp
ten35856112te_n
tench105620002tench
tend56433772tend
tens45647412tens
tent46159862tent
tenths94412662tenths
tents56434212tents
tenty86121602tenty
tepa66021682tepa
term66233152term
tern46134802tern
test48651622test
testa54822042testa
tests56530192tests
testy85419062testy
tetchy1436002tetchy
tether93716102tether
tetra53417952tetra
tetri52716452tetri
teuch105214852teuch
teugh95511612teugh
tew66640152te_w
tews76431642tews
text116033932text
texts125515042texts
theta83414572theta
tilth85515362tilth
tit36771042tit_
tithe85319702tithe
titi47130612titi
tits46145032tits
tooth88020182tooth
toph96326872toph
tosh74826812tosh
tot38884772tot_
tote46643672tote
tots46654122tots
tret46653532tret_
trets55928022trets
troth85622202troth
truth85214152truth
tush74523902tush
tut36758092tut_
tuts45838452tuts
tutu48423172tutu
tythe115210452tythe
vet65958522vet_
vetch134411842vetch
veto76622992veto
vets76835092vets
wet65966622wet_
wets75940292wets
with105730472with
yeah106725412yeah
yech127220532yech
yeh97135772ye_h
yet66960692yet_
yeti75823212yeti
yett76434492yett
zeta135121642zeta

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.0632836365.1
2DLD Change Limit298721910.95031444.2
3Display Results1911910.0503820.0
 (SQL Overall)1786911911.063168100.7
 
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.