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

224 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
gestating1122998(None) 
estating92614991_estating
restating102319411restating
gelating103015732ge_lating
gemmating1576442gemmating
gestation10310662gestation
gestations1139772gestations
gestative1347302gestative
gesturing1136652gesturing
getting93316562ge_t_ting
hesitating1448002hesitating
instating10812212instating
reseating102421532reseating
reslating102516992reslating
restaging112410852restaging
restarting11310662restarting
stating83725162__stating
unstating10711212unstating
aerating92821003ae_rating
aestivating1545803aestivating
agitating1138853agitating
astatine8313533_astatine
beating104326873be__ating
berating113220763be_rating
besetting12268423besetting
beshaming1735673beshaming
besotting12256873besotting
besteading1446023besteading
besting104923923bes__ting
bestowing1535803bestowing
betaking153010153be_taking
betting103921403be_t_ting
caseating12311743caseating
castrating1349773castrating
debating123213733de_bating
defatting1436103defatting
defeating142311973defeating
deflating142610713deflating
delating103119603de_lating
derating103222283de_rating
deratting1139513deratting
desalting1138843desalting
descanting1446923descanting
deserting11713143deserting
desisting112810383desisting
desolating1239463desolating
despiting13179323despiting
destain8412083desta_in_
destaining1267943destaining
destains9311813desta_ins
destining11311433destining
devastating1644703devastating
deviating14311083deviating
dictating1338883dictating
disrating11714553disrating
distasting1248023distasting
eating75134403_e__ating
egesting1039013eges__ting
elating83423083_e_lating
equating18310113_equating
escaping1347063_escaping
escoting1158713_escoting
essaying1235033_essaying
estimating1348883_estimating
estivating1447633_estivating
estraying1338293_estraying
estreating11710363_estreating
fellating1339243fellating
festering132413173festering
festinating1547373festinating
fetting113517873fe_t_ting
gasting95022763gas__ting
gating84826953g___ating
gearing92818843ge__aring
gelatin83514733ge_latin_
gelatine93213303ge_latine
gelatins93414093ge_latins
geminating1447753geminating
generating12310383generating
gentling1048453gent_ling
gestalten1042703gestalten_
gestaltist1154293gestaltist
gestate83614073gestat__e
gestated102910573gestat_ed
gestates93213733gestat_es
gestational1245113gestational
gestatory1344523gestatory
gettering112310033gettering
gitting93215703g_it_ting
gloating102611463g_loating
glutting10247643glut_ting
gradating1237313gradating
grating93923183g__rating
gritting10309983grit_ting
guesting1058463gues__ting
gusseting1173963gusseting
gustation1047963gustation
gustations1147233gustations
gustative1345683gustative
gusting93917163gus__ting
gutting93415923g_ut_ting
gyrating1337453g_yrating
heating114024323he__ating
hebetating1645793hebetating
imitating1238763imitating
jesting154317713jes__ting
jetting153815343je_t_ting
lactating1239183lactating
legating102313113le_gating
letting83218533le_t_ting
levitating1446653levitating
lustrating1147783lustrating
mediating13311203mediating
meditating1448123meditating
messaging1345343messaging
metaling111613723me_taling
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
misstating13129313misstating
mistaking1699693mistaking
mutating112211753_mutating
negating102012833ne_gating
nesting84320443nes__ting
nestling958893nest_ling
netting84018763ne_t_ting
nictating1237573nictating
notating92513343_notating
nutating92411953_nutating
nystatin1145093nystatin_
nystatins1244753nystatins
outstating1139363outstating
overstating15410733overstating
pestering122315663pestering
pestling111010253pest_ling
petting103720953pe_t_ting
postdating1447163postdating
postmating1548603postmating
rebating112418343re_bating
recoating121317463recoating
recrating121318793recrating
redating102620173re_dating
reflating132514713reflating
regrating111316213regrating
reheating132314913reheating
reinstating1248113reinstating
relating92725443re_lating
remating112322413re_mating
repeating122618983repeating
replating122217403replating
resawing122311433res_awing
resaying122512453res_aying
rescaling122212013rescaling
resealing102115673resealing
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
reshaping1557743reshaping
reshaving1657273reshaving
resifting133512093resifting
resinating11313733resinating
resisting103215313resisting
resiting93521123res_iting
resitting103414873resitting
resituating1247543resituating
resoaking1439373resoaking
resonating11311263resonating
resorting10614613resorting
respacing1438893respacing
respading1338803respading
respiting121912863respiting
restabling1337653restabling
restacking1737183restacking
restaffing1744193restaffing
restamping1565213restamping
restation9316913restation
restations10315843restations
resting85031183res__ting
restoking1438193restoking
restoring10314613restoring
restring91518783rest_ring
restyling1337923restyling
resulting10311083resulting
retaking133114283re_taking
retaping113012553re_taping
retasting102513413re_tasting
retaxing162311333re_taxing
retting83425883re_t_ting
rotating92614553_rotating
sating74735453__s_ating
seating84130683__seating
sedating103014113se_dating
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
setting83621393se_t_ting
skating123613853__skating
slating83724653__slating
spectating1546623spectating
staging93818373__staging
staking123919803__staking
staling83925423__staling
staning83922243__staning
staring84527053__staring
starting93116173__starting
statin63921473__statin_
statins73719773__statins
staving113915703__staving
staying114017323__staying
testing86021053tes__ting
unseating10713203unseating
upstaging1344113upstaging
upstaring1235963upstaring
upstarting1343883upstarting
vegetating1545703vegetating
vesicating1646893vesicating
vesting114618683ves__ting
vesturing1337203vesturing
vetting114216563ve_t_ting
westering132112643westering
westing115020273wes__ting
wetting114117383we_t_ting
zesting174515333zes__ting

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 Filter1786911486410.403443402.0
2DLD Change Limit1486412247.65619415.0
3Display Results2242240.1102036.4
 (SQL Overall)1786912248.16921874.3
 
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.