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

281 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
gestates9321373(None) 
estates74520181_estates
gestate83614071gestate_
gestated102910571gestated
restates83423431restates
testates83615451testates
estate64719762_estate_
estated83715572_estated
gelates83219582ge_lates
gemmates13307672gemmates
geotaxes1644742geotaxes
gestalten1042702gestalten
gestalts955492gestalts
gestapos1153912gestapos
gestes75721392ges__tes
gestures9310012gestures
hesitates1269792hesitates
instates81615832instates
metates92720012me_tates
pectates122213952pectates
reslates83619502reslates
restages92815772restages
restate73824882restate_
restated93120182restated
states64337082__states
testate73916232testate_
unstates81314992unstates
upstates10189642upstates
acetates102013063acetates
aerates74627493ae_rates
aesthetes1246233aesthetes
aestivates13107363aestivates
agemates111110023age_mates
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
enates64026433_e_nates
entases72816273_entases
equates162012323_equates
ergates8314493_ergates
escapes113811673_escapes
esthetes1147743_esthetes
estimates11911363_estimates
estivates12109753_estivates
etapes85415293_e_tapes
fellates11312753fellates
ferrates113013423ferrates
festinates1348943festinates
gallates92815523gallates
gates65939513g___ates
gelate73421253ge_late_
gelated93615633ge_lated
gelatis83313513ge_latis
gelatos83111513ge_latos
geminates12310043geminates
gemmate12418383gemmate_
gemmated14336293gemmated
gemotes103712143ge_motes
gemstones1245563gemstones
generates10312713generates
genettes938303genettes
gentes75324163ge__ntes
gentiles93713523gentiles
gentles83714343gent_les
gentries91315263gentries
geotaxis1644183geotaxis
gessoes838293ges_soes
gestalt8411173gesta_lt
gestaltist1154293gestaltist
gestapo1044493gesta_po
gestating11229983gestating
gestation10310663gestation
gestations1139773gestations
gestative1347303gestative
gestatory1344523gestatory
geste65920693ges__te_
gests66028813ges__t_s
gesture839243gesture_
gestured1036993gestured
gesturer935983gesturer
gesturers1044283gesturers
getas65421483ge_ta__s
getter74117613ge_t_ter
getters84216103ge_t_ters
gradates10510783gradates
grates75429893g__rates
gustables12165223gustables
gustoes879873gust_oes
guttate8328903guttate_
guttated10266873guttated
gyrates113610263g_yrates
hastate10313913hastate_
hebetates1446433hebetates
hectares1338853hectares
hektares1535813hektares
heptanes1339003heptanes
hesitate1169973hesitate_
hesitated1377783hesitated
hesitater1276923hesitater
hesitaters1374853hesitaters
hessites1138613hessites
hostages122311693hostages
imitates10310503imitates
instate71616483instate_
instated91613343instated
intestates10159433intestates
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_
penates93321603pe_nates
pentanes10316083pentanes
pesades10310903pes_ades
pestles93217693pest_les
petites93820203pe_tites
postages112815323postages
postdates1248863postdates
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
sedates83418043se_dates
senates73322613se_nates
sensates8511143sensates
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
substates111410333substates
tates55444983___tates
tectites1039993tectites
tektites1236613tektites
tentages91011043tentages
testacies1148373testacies
testae64216253testa_e_
testator847373testator
testators947333testators
testees74215913test_ees
testes65125823tes__tes
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.406440125.6
2DLD Change Limit1461622816.47022590.7
3Display Results2812810.1102554.5
 (SQL Overall)1786912816.98625578.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.