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

128 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
setae5602622(None) 
seta45637311seta_
setal56430901setal
antae56828292antae
beta66234132beta_
betake124512702betake
betas75528762betas
cetane8315282cetane
cete64934782cet_e
estate64719762estate
eta35834192_eta_
etape74413702_etape
etas46432272_etas
feta76528902feta_
fetal85623372fetal
fetas85624402fetas
fete75734922fet_e
geta56627442geta_
getas65421482getas
jete115927252jet_e
lethe85717302lethe
meta65932412meta_
metage93114452metage
metal75427382metal
metate82720532metate
mete64438132met_e
metre74821302metre
petal76526892petal
retag63618412retag
retake104718532retake
retape83917682retape
retax124517972retax
rete44944132ret_e
retie55735302retie
sae38365182s__ae
satay84718462satay
sate45556102sat_e
sea36161292se_a_
seal45654372se_al
seam66645972se_am
sear47353842se_ar
seas45755272se_as
seat47575562se_at
seated75131062seated
seater64534162seater
seats54844342seats
sedan65620422sedan
sedate73019812sedate
sedge75019972sedge
see35772262se__e
seethe93712482seethe
segue6314412segue
seine55732872seine
seise54727852seise
seitan62613232seitan
seize143819502seize
selah8319612selah
selle54428312selle
seme65836652se_me
senate63725172senate
sene46848052se_ne
sense55526822sense
sente56432882sente
sepal77723002sepal
septa75518082septa_
septage1078402septage
septal84513382septal
septate9511872septate
sera46141392sera_
serac75925202serac
serai56830162serai
seral56336382seral
serape84818412serape
sere46153472se_re
serge64727472serge
serve85425962serve
sesame8311012sesame
set36681252set__
seton55223542seton
setose65114772setose
sets45549502set_s
sett45949052set_t
settee63721022settee
setter64023722setter
settle63915662settle
setts55124322setts
setup73915822setup
sewage10310732sewage
sewan85921292sewan
sewar85421102sewar
sextan13389642sextan
sitar54820542sitar
site47052412sit_e
skate94721552skate
slate55438282slate
spae65034322s_pae
spate74731582spate
stab67329932s_tab
stade64825302s_tade
stag57332002s_tag
stage65330192s_tage
stake95927532s_take
stale55637102s_tale
stane55933002s_tane
star48037762s_tar
stare54440262s_tare
stat47352692s_tat
state56237332s_tate
stave85324992s_tave
staw78627692s_taw
stay78333722s_tay
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
stelae63716482stelae
stele55026842stele
stere55328542stere
stoae55024262stoae
stye76218972s_tye
tae38267052__tae
telae54323292telae
testae64216252testae
tsetse664692tsetse
venae85920982venae
vitae84217632vitae
zeta135121642zeta_
zetas145018162zetas

Search took 3 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.296603685.8
2DLD Change Limit538001281.65632487.9
3Display Results1281280.0304266.7
 (SQL Overall)1786911281.98290156.9
 
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.