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

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

350 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
testate7391623(None) 
estate64719761_estate
gestate83614071gestate
restate73824881restate
testae64216251testa_e
testates83615451testates
bistate9313822bistate
costate94019272costate
dentate8315152dentate
estated83715572_estated
estates74520182_estates
gestated102910572gestated
gestates93213732gestates
hastate10313912hastate
hesitate1169972hesitate
instate71616482instate
intestate9159872intestate
metate82720532me_tate
pectate112214692pectate
peltate92013772peltate
reslate73520592reslate
restage83316192restage
restated93120182restated
restates83423432restates
septate9511872septate
state56237332__state
tectite9310582tectite
tektite1136882tektite
tentage81010642tentage
ternate7415482ternate
testa54822042testa__
testable101412622testable
testacy1235962testacy
testator847372testator
testee64323302test_ee
tristate8311032tristate
unstate71916212unstate
upstate91610492upstate
acetate92514753acetate
aerate64830553ae_rate
aesthete1145853aesthete
aestivate12127663aestivate
agitate8312063agitate
ansate64517863ans_ate
antistate9410143antistate
apostate1049853apostate
aristate8312133aristate
astute6310763_astute
bedmate1239433bedmate
berate84729023be_rate
beshame1447483beshame
bespake15436963bespake
betake124512703be_take
caseate9314783caseate
castrate10313863castrate
centare93113703centare
cerate84829463ce_rate
cesta75419483cesta__
cestas85018543cesta_s
cestode1037963cestode
cetane8315283ce_tane
costae85319683costa_e
cristate10310603cristate
curtate9312643curtate
cuspate1138233cuspate
dealate83617843dealate
debate94419193de_bate
deflate113613943deflate
delate73827753de_late
dentated10411703dentated
derate74531233de_rate
desolate9411993desolate
despite10410123despite
destain8412083destain
destine83719953destine
devastate1344953devastate
deviate11312713deviate
dictate10311663dictate
disrate81418523disrate
distaste939943distaste
edentate947703edentate
elate55335883_e_late
eluate62315433_eluate
enate54428143_e_nate
equate152012463_equate
ergate7315143_ergate
escape103811663_escape
esthete1047433_esthete
estimate10912003_estimate
estivate111010003_estivate
etape74413703_e_tape
fellate10313433fellate
fermate122813003fermate
ferrate103014043ferrate
festal94213563festa_l
festinate1249473festinate
festive1339773festive
fissate103010033fissate
fossate10388603fossate
gelate73421253ge_late
gemmate12418383gemmate
gestalt8411163gestalt
gestalten1042703gestalten
gestalts955493gestalts
gestapo1044493gestapo
gestative1347303gestative
geste65920693ges__te
gesture839243gesture
guttate8328903guttate
hebetate1347053hebetate
hectare1238463hectare
hektare1435503hektare
heptane1238363heptane
hesitated1377783hesitated
hesitater1276923hesitater
hesitates1269793hesitates
hessite1038993hessite
hostage113111233hostage
imitate9310873imitate
instated91613343instated
instates81615833instates
interstate10710973interstate
intestates10159433intestates
iterate71119113ite_rate
lactate9312693lactate
legate72917453le_gate
levitate1137933levitate
lustrate8310443lustrate
lysate9388103lys_ate
mediate103415213mediate
meditate11310623meditate
meltage1037953meltage
message1037833message
messmate1246393messmate
mestee84523883mest_ee
metage93114453me_tage
metates92720013me_tates
misate81222693mis_ate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
misstate10711343misstate
mistake131312623mistake
mutate83017483_mutate
negate72915573ne_gate
neonate7311333neonate
nervate1039523nervate
nestable101613673nestable
nestle63013953nest_le
nictate9310223nictate
notate63217863_notate
nutate63017373_nutate
onstage838363onstage
outate62923403_outate
outstate81411993outstate
overstate121010863overstate
pectase112410363pectase
pectates122213953pectates
pedate93117763pe_date
pennate93314033pennate
pentane9415743pentane
pesade9311103pes_ade
pestle83215843pest_le
petite84320653pe_tite
postage103214853postage
postdate1139653postdate
potentate1197253potentate
prostate10314533prostate
rebate84424113re_bate
recrate92621653recrate
redate74124683re_date
reflate103516263reflate
regrate82618663regrate
reinstate948893reinstate
relate64033633re_late
remate84428683re_mate
replate93420053replate
resale64025543res_ale
resat55139683res_at_
rescale93215473rescale
reseat64131493reseat_
reseated93220263reseated
reseats74319583reseats
reshape1249043reshape
reshave1338603reshave
resinate8316773resinate
resite64128453res_ite
resituate948613resituate
reslated93517523reslated
reslates83619503reslates
resonate8513513resonate
respace11310913respace
respade1039573respade
respite9513033respite
restable101618443restable
restack1339433restack
restaff1339013restaff
restaged103011863restaged
restages92815773restages
restamp1146483restamp
restart7320033restart
restarted10410053restarted
restarts8310873restarts
restive10315933restive
restoke116113903restoke
restore75822973restore
restyle1038763restyle
retake104718533re_take
retape83917683re_tape
retaste72313133re_taste
roseate7613453roseate
rostrate8313843rostrate
rotate63320343_rotate
sate45556103__s_ate
scutate9310323scutate
seatmate1048573seatmate
sedate73019803se_date
senate63725143se_nate
sensate7311883sensate
septage1078403septage
seriate73722473seriate
serrate73017543serrate
sesame8311013ses_ame
sestet6826203sestet_
sestets7911473sestets
sestine73017923sestine
setae56026223se_ta_e
skate94721543__skate
slate55438283__slate
spate74731583__spate
spectate12248833spectate
stacte82113913__stacte
stade64825303__stade
stage65330193__stage
stake95927533__stake
stale55637103__stale
stane55933003__stane
stare54440263__stare
stat47352693__stat_
stated75427833__stated
stater64427563__stater
states64337083__states
stats55933363__stats
statue66015323__statue
stave85324993__stave
stearate839723stearate
steatite8310583steatite
stellate8310503stellate
substate101711093substate
tannate71813523tannate
tartare73012683tartare
tartrate899683tartrate
tastable101511973tastable
taste55127233tas__te
tate44748603___tate
teacake1335453teacake
teammate1245613teammate
tease55428713te__ase
teat45963633te__at_
teataster944563teataster
teated74924023te__ated
teatime9310083teatime
teats55636813te__ats
teaware1048143teaware
tecta74215523tecta__
tectal83713253tecta_l
tectites1039993tectites
teenage8108053teenage
teethe94511313teet_he
tektites1236613tektites
telae54323293te_la_e
telltale844423telltale
template1238433template
tenace82715693te_nace
teniae64517353tenia_e
tentacle1037693tentacle
tentages91011043tentages
tentative1247813tentative
tentie62521183tent_ie
teosinte845543teosinte
terete6319333te_rete
tergite8311003tergite
termite9313893termite
terrace93311833terrace
terrae62915203terra_e
terrane72814223terrane
tesla55612603tesla__
teslas64212173tesla_s
tesselate944183tesselate
test48651623tes__t_
testacean1142363testacean
testacies1148373testacies
testament1166953testament
testators947333testators
testatrix1652033testatrix
tested74421523test_ed
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testicle1037443testicle
testier74015643testier
testify13246943testify
testily102910803testily
testing86021053testing
testis64916713test_is
teston6313303test_on
testons7313553testons
testoon748363testoon
tests56530193tes__ts
testudo843363testudo
testy85419063tes__ty
tetany959843te_tany
tetter64322453te_t_ter
textile1437223textile
texture1497083texture
thecate123210023thecate
tisane6311573tis_ane
titrate72215573titrate
toccate1138773toccate
toeplate1047613toeplate
togate74515683t_ogate
toluate7159343toluate
tostada894953tostada
tostado895953tostado
tractate10411003tractate
trestle72611363trest_le
tsade64311123t_s_ade
tsetse664693tset_se
tubate82813173t_ubate
tungstate1042873tungstate
unstated91615813unstated
unstates81314993unstates
upstage10167443upstage
upstare9158683upstare
upstater10156663upstater
upstates10189643upstates
vegetate1246673vegetate
velate93720143ve_late
ventage11109623ventage
vesicate131210053vesicate
vesta86618303vesta__
vestal94615573vesta_l
vestals104612333vestals
vestas95916683vesta_s
vestee94319153vest_ee
vestige1137433vestige
vesture10310373vesture
vittate10409733vittate
wastage11109253wastage

Search took 9 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 Filter1786911340270.203880251.2
2DLD Change Limit1340273507.90616952.6
3Display Results3503500.1432447.6
 (SQL Overall)1786913508.25221654.3
 
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.