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

134 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
teths8541851(None) 
beths105519221beths
eths76619521_eths
heths116317781heths
meths105320231meths
techs106915831techs
tenths94412661tenths
teth76327881teth_
tets45847451tet_s
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
maths105624022maths
metes74736212metes
meth95827842meth_
metis75025902metis
moths106021552moths
myths135911602myths
nets45941532net_s
netts55320722netts
oaths86117312oaths
paths105521382paths
pechs125516202pechs
pehs95625762pe_hs
pets66248332pet_s
piths105817542piths
rets45352562ret_s
ruths85714642ruths
sets45549502set_s
setts55124322setts
soths86218622soths
stets55423912stet_s
tachs105820932tachs
tates55444982tates
tats46858132tat_s
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492te_as
teats55636812teats
tech95925442tech_
techy135612012techy
teds54932572te_ds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582te_es
teeth87315852teeth_
teethe94511312teethe
teethes103611652teethes
teffs115111732teffs
teggs74710742teggs
tegs56031492te_gs
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692te_ls
temps95417132temps
tends65425582tends
tens45647412te_ns
tenth85421832tenth_
tents56434212tents
tepas76521682tepas
terms75523472terms
terns55226872terns
testes65125822testes
testis64916712testis
tests56530192tests
tet39274982tet__
tetchy1436002tetchy
tether93716102tether
tethers103815312tethers
tetra53417952tetra
tetras63017612tetras
tetri52716452tetri
tetris62816292tetris
tews76431642te_ws
texas126514932texas
texts125515042texts
thetas93011572thetas
tilths9459372tilths
tithe85319702tithe
tithes94720212tithes
titis56023812titis
tits46145032tit_s
tooths96013802tooths
tophs105220052tophs
totes55139682totes
tots46654122tot_s
trets55928022tret_s
troths95414152troths
truths9449502truths
tuts45838452tut_s
tutus55214812tutus
tythe115210452tythe
tythes12419702tythes
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 Filter178691538000.0901985455.6
2DLD Change Limit538001341.39338621.7
3Display Results1341340.0304466.7
 (SQL Overall)1786911341.513118103.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.