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

320 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
testates8361545(None) 
estates74520181_estates
gestates93213731gestates
restates83423431restates
testate73916231testate_
estate64719762_estate_
estated83715572_estated
gestate83614072gestate_
gestated102910572gestated
hesitates1269792hesitates
instates81615832instates
intestates10159432intestates
metates92720012me_tates
pectates122213952pectates
reslates83619502reslates
restages92815772restages
restate73824882restate_
restated93120182restated
states64337082__states
tectites1039992tectites
tektites1236612tektites
tentages91011042tentages
testacies1148372testacies
testae64216252testa_e_
testator847372testator
testators947332testators
testees74215912test_ees
testes65125822tes__tes
unstates81314992unstates
upstates10189642upstates
acetates102013063acetates
aerates74627493ae_rates
aesthetes1246233aesthetes
aestivates13107363aestivates
agitates9310883agitates
apostates1149163apostates
bedmates1349183bedmates
berates94126873be_rates
beshames1537203beshames
betakes134212523be_takes
bistate9313823bistate_
caseates10313713caseates
castrates11312673castrates
centares102913893centares
cerates95428253ce_rates
cestas85018543cesta__s
cestodes1138203cestodes
cestuses1038083cestuses
cetanes9315133ce_tanes
costate94019273costate_
dealates92716683dealates
debates103718533de_bates
deflates123013943deflates
delates83526283de_lates
dentate8315153dentate_
dentated10411703dentated
derates84028893de_rates
desolates10311793desolates
despites11410313despites
destains9311813destains
destines93619663destines
devastates1444663devastates
deviates12312733deviates
dictates11311383dictates
disrates91118153disrates
distastes1039633distastes
distaves12311403distaves
ectases92911673_ectases
edentates1046953edentates
elates65032363_e_lates
eluates72014683_eluates
enates64026423_e_nates
entases72816273_entases
equates162012323_equates
ergates8314493_ergates
escapes113811673_escapes
esthetes1147743_esthetes
estimates11911363_estimates
estivates12109753_estivates
etapes85415293_e_tapes
fellates11312753fellates
ferrates113013423ferrates
festinates1348943festinates
gelates83219583ge_lates
gemmates13307673gemmates
geotaxes1644743geotaxes
gestalten1042703gestalten
gestalts955493gestalts
gestapos1153913gestapos
gestes75721393ges__tes
gestures9310013gestures
hastate10313913hastate_
hebetates1446433hebetates
hectares1338853hectares
hektares1535813hektares
heptanes1339003heptanes
hesitate1169973hesitate_
hesitated1377783hesitated
hesitater1276923hesitater
hesitaters1374853hesitaters
hessites1138613hessites
hostages122311693hostages
imitates10310503imitates
instate71616483instate_
instated91613343instated
interstates11710203interstates
intestate9159873intestate_
iterates81317823ite_rates
lactates10311223lactates
legates82917683le_gates
levitates1247863levitates
lustrates939463lustrates
lysates10317473lys_ates
mediates112814063mediates
meditates1239813meditates
meltages1148243meltages
mesdames1346043mesdames
messages1138233messages
messmates1346233messmates
mestees94617753mest_ees
metages102714973me_tages
metate82720533me_tate_
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
misstates11710633misstates
mistakes141213413mistakes
mutates92215793_mutates
negates83215843ne_gates
neonates8310063neonates
nestles73015463nest_les
nictates1039593nictates
notates72817483_notates
nutates73214973_nutates
outstates91710753outstates
overstates131110113overstates
pectases122411193pectases
pectate112214693pectate_
peltate92013773peltate_
penates93321593pe_nates
pentanes10316083pentanes
pesades10310903pes_ades
pestles93217693pest_les
petites93820203pe_tites
postages112815323postages
postdates1248863postdates
potentates12106333potentates
prostates11314423prostates
rebates95123183re_bates
recrates102420373recrates
redates83423873re_dates
reflates113115663reflates
regrates92618403regrates
reinstates1048293reinstates
relates73731433re_lates
remates93827113re_mates
replates102919273replates
resales74724903res_ales
rescales103414573rescales
reseated93220263reseated
reseats74319583reseat_s
reshapes1338803reshapes
reshaves1438733reshaves
resinates9314763resinates
resites74027793res_ites
resituates1047753resituates
reslate73520593reslate_
reslated93517523reslated
resonates9412403resonates
respaces12311043respaces
respades1139853respades
respites10513243respites
restables111511423restables
restacks1438093restacks
restaffs1444783restaffs
restage83316193restage_
restaged103011863restaged
restamps1234703restamps
restarted10410053restarted
restarts8310873restarts
restokes125213043restokes
restores85222993restores
restyles1139193restyles
retakes113718863re_takes
retapes93917423re_tapes
retastes82212903re_tastes
retaxes143615093re_taxes
rotates72819773_rotates
sates54949323__s_ates
seatmates1157823seatmates
sedates83418033se_dates
senates73322583se_nates
sensates8511133sensates
septages1168263septages
septate9511873septate_
seriates82620673seriates
serrates82617023serrates
sesames9310743ses_ames
sestets7911473sestet_s
sestines82717243sestines
skates104219403__skates
slates64934063__slates
spates85028173__spates
spectates13228813spectates
stactes91914633__stactes
stades74626243__stades
stages75629493__stages
stakes103927293__stakes
stales65538293__stales
stanes64933403__stanes
stapes85028733__stapes
stares66038753__stares
stases64225563__stases
state56237333__state_
stated75427833__stated
stater64427563__stater
staters73922343__staters
stats55933363__stat_s
statues74614903__statues
status65515213__status
staves94525193__staves
stearates939453stearates
steatites939843steatites
substates111410333substates
tannates81911953tannates
tartrates979563tartrates
tastes64126423tas__tes
tates55444983___tates
teacakes1435883teacakes
teammates1345673teammates
teases65426273te__ases
teataster944563teataster
teatasters1043883teatasters
teated74924023te__ated
teatimes1039443teatimes
teats55636813te__at_s
teawares1148083teawares
tectite9310583tectite_
teethes103611653teet_hes
tektite1136883tektite_
telltales944393telltales
telotaxes1644643telotaxes
templates1348273templates
tenaces92814513te_naces
teniases838623teniases
tentacles1146713tentacles
tentage81010643tentage_
tentatives1345483tentatives
teosintes944553teosintes
tergites9310543tergites
termites10313693termites
ternate7415483ternate_
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
teslas64212173tesla__s
tesselates1043933tesselates
testa54822043testa___
testable101412623testable
testacean1142363testacean
testaceans1251913testaceans
testaceous1253313testaceous
testacy1235963testa_cy
testament1166953testament
testaments1265353testaments
testatrices1352803testatrices
testatrix1652033testatrix
testatrixes1852093testatrixes
tested74421523tes__ted
testee64323303tes__tee
tester64227153tes__ter
testers74124543test_ers
testicles1146773testicles
testier74015643test_ier
testiest82715223test_iest
testifies12139263testifies
testiness9209753testiness
testis64916713tes__tis
testons7313563test_ons
testoons837323testoons
tests56530193tes__t_s
testudos943053testudos
tetanies8513553te_tanies
tetanus737933te_tanus
tetter64322453te_t_ter
tetters74320473te_t_ters
texases1437573te_xases
textiles1536833textiles
textures1597523textures
tipstaves1443353tipstaves
tisanes7311853tis_anes
titrates82314663titrates
toeplates1147183toeplates
toluates8138903toluates
tostadas994523tostadas
tostados995073tostados
tractates1159763tractates
trestles83012553trest_les
tristate8311033tristate_
tsades74310993t_s_ades
tsetses785453tset_ses
tungstates1142683tungstates
unstate71916213unstate_
unstated91615813unstated
upstages11147373upstages
upstares10178583upstares
upstate91610493upstate_
upstater10156663upstater
upstaters11174803upstaters
vegetates1346403vegetates
ventages12119773ventages
veritates12310973veritates
vesicates14119033vesicates
vestals104612333vesta_ls
vestas95916683vesta__s
vestees103513173vest_ees
vestiges1238243vestiges
vestries11314053vestries
vestures11311043vestures
wastages12109753wastages

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461623207.39019778.3
3Display Results3203200.1402285.7
 (SQL Overall)1786913207.95322468.4
 
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.