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

265 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
gestated10291057(None) 
estated83715571_estated
gestate83614071gestate_
gestates93213731gestates
restated93120181restated
dentated10411702dentated
estate64719762_estate_
estates74520182_estates
gelated93615632ge_lated
gemmated14336292gemmated
gestalten1042712gestalten
gestured1036992gestured
guttated10266872guttated
hesitated1377782hesitated
instated91613342instated
reseated93220262reseated
reslated93517522reslated
restaged103011862restaged
restarted10410052restarted
restate73824882restate_
restates83423432restates
stated75427832__stated
testate73916232testate_
testates83615452testates
unstated91615812unstated
acetated112010683acetated
aerated85322373ae_rated
aestivated14106293aestivated
agitated1038413agitated
ansated84214003ans_ated
belated103520013be_lated
berated104422133be_rated
beshamed1635733beshamed
beslaved1435023beslaved
besotted1135843besotted
besteaded1345073besteaded
bested94922763bes__ted
bestowed14156623bestowed
betaxed17307023be_taxed
betted94721163be_t_ted
bistate9313823bistate_
caseated11310713caseated
castrated1239513castrated
cerated103922473ce_rated
costate94019273costate_
cristated1247423cristated
cuspated1335913cuspated
dealated103213603dealated
debated113916083de_bated
defatted1335673defatted
defeated132812163defeated
deflated133412303deflated
delated93722873de_lated
dentate8315153dentate_
derated93623503de_rated
deratted1048403deratted
desalted1038313desalted
descanted1336673descanted
deserted101012203deserted
desisted1039783desisted
desolated1139653desolated
despited1248323despited
destained1158253destained
destined103312453destined
devastated1544123devastated
deviated13311043deviated
dictated1239203dictated
disrated10915573disrated
distasted1137963distasted
egested938123eges__ted
elated74725823_e_lated
equated171910403_equated
escaped12388853_escaped
escoted1038183_escoted
essayed1134013_essayed
estimated12109443_estimated
estivated13108323_estivated
estrayed1236393_estrayed
estreated1039563_estreated
fellated1239563fellated
festered122512113festered
festinated1447533festinated
fetted104817893fe_t_ted
galeated104111573galeated
gasted84821583gas__ted
gated75329773g___ated
geared85317743ge__ared
gelate73421253ge_late_
gelates83219583ge_lates
geminated1338553geminated
gemmate12418383gemmate_
gemmates13307673gemmates
generated11310203generated
gentled9389093gent_led
geotaxes1644743geotaxes
gessoed935743ges_soed
gestalt8411173gesta_lt
gestalts955493gestalts
gestapo1044493gesta_po
gestapos1153913gestapos
gestating11229983gestating
gestation10310663gestation
gestative1347303gestative
gestatory1344523gestatory
geste65920693ges__te_
gestes75721393ges__tes
gesture839243gesture_
gesturer935983gesturer
gestures9310013gestures
getter74117613ge_t_ter
gettered10258613gettered
gewgawed1741103gewgawed
gitted84015053g_it_ted
gloated93511533g_loated
globated1265753globated
glutted937243glut_ted
gradated1157433gradated
grated84523923g__rated
gritted94110903grit_ted
guested9157713gues__ted
gusseted1043553gusseted
gusted84316723gus__ted
guttate8328903guttate_
gutted84716363g_ut_ted
gyrated12428413g_yrated
hastate10313913hastate_
heated104525593he__ated
hebetated1544663hebetated
hesitate1169973hesitate_
hesitater1276923hesitater
hesitates1269793hesitates
imitated1138263imitated
instate71616483instate_
instates81615833instates
jested144416503jes__ted
jetted143915083je_t_ted
lactated1138863lactated
legated92513983le_gated
letted74118543le_t_ted
levitated1346413levitated
lustrated1037963lustrated
meated94222403me__ated
mediated123011873mediated
meditated1348083meditated
messaged1235543messaged
metaled102913883me_taled
metate82720533me_tate_
metates92720013me_tates
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
misstated1278973misstated
mutated102712253_mutated
negated93413233ne_gated
nested74720063nes__ted
nestled8349913nest_led
netted74118713ne_t_ted
nictated1137793nictated
notated82713663_notated
nutated83113423_nutated
outstated10169813outstated
overstated14119443overstated
pectate112214693pectate_
pectates122213953pectates
peltate92013773peltate_
pennated11299543pennated
pestered112814973pestered
pestled102711453pest_led
petaled103614153pe_taled
petted94121523pe_t_ted
postdated1346883postdated
rebated103619703re_bated
recoated113416783recoated
recrated112918603recrated
redated93120923re_dated
reflated123514293reflated
regrated102816333regrated
reheated122415003reheated
reinstated1147283reinstated
related83327573re_lated
remated103522473re_mated
repeated113117443repeated
replated112817523replated
resawed113111183res_awed
rescaled113311303rescaled
resealed92713973resealed
resected112514743resected
resented92716963resented
reshaped1437203reshaped
reshaved1536873reshaved
resifted12310153resifted
resinated10413283resinated
resisted9312693resisted
resited85122423res_ited
resituated1147323resituated
reslate73520593reslate_
reslates83619503reslates
resoaked1337943resoaked
resonated10510613resonated
resorted9313493resorted
respaced1338503respaced
respaded1238133respaded
respited11410813respited
restabled12148963restabled
restacked1636483restacked
restaffed1653753restaffed
restage83316193restage_
restages92815773restages
restamped1444433restamped
rested74430783res__ted
restoked135710533restoked
restored96417193restored
restyled1236953restyled
resulted939713resulted
retaped103814283re_taped
retasted92412113re_tasted
retaxed153512233re_taxed
retted74826313re_t_ted
rotated82715293_rotated
sated66238533__s_ated
seated75131063__seated
sedated93714353se_dated
sensated938193sensated
septate9511873septate_
seriated92717023seriated
serrated92513433serrated
skated114414883__skated
slated75028313__slated
spectated14236593spectated
staged84521563__staged
staked114621943__staked
staled74728103__staled
staned74824643__staned
stared75429873__stared
started84217323__started
state56237333__state_
stater64427563__stater
states64337083__states
statued8459893__statued
staved103918053__staved
stayed104817273__stayed
teated74924023te__ated
testae64216253testa_e_
testator847373testator
tested74421523tes__ted
unsated83419933uns_ated
unseated91317683unseated
unstate71916213unstate_
unstates81314993unstates
unstayed12168393unstayed
upstaged12135243upstaged
upstared11156573upstared
upstarted1244213upstarted
upstate91610493upstate_
upstater10156663upstater
upstates10189643upstates
vegetated1445083vegetated
vesicated15117653vesicated
vested104217353ves__ted
vestured1237463vestured
vetted104316323ve_t_ted
vistaed1138023vista_ed
westered122511873westered
wetted103717023we_t_ted
zested164214043zes__ted

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.470380193.6
2DLD Change Limit1461622656.90621164.5
3Display Results2652650.0932849.5
 (SQL Overall)1786912657.46923924.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.