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

127 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
gestation1031066(None) 
gestations1139771gestations
gustation1047961gustation
restation9316911restation
cessation1176852cessation
dentation10315242dentation
fetation11613142fe_tation
gelation93014432ge_lation
gemmation1445962gemmation
gestating11229982gestating
gestational1245112gestational
gestative1347302gestative
gustations1147232gustations
guttation1046172guttation
hesitation1349632hesitation
mentation11313982mentation
peltation11312962peltation
restations10315842restations
station72717242__station
aeration8319933ae_ration
aestivation1447923aestivation
agitation10311223agitation
attestation1145183attestation
betatron1045233be_tatron
caseation1199513caseation
cassation1197913cassation
castration12410803castration
cessations1256473cessations
citation10314363_citation
dealation10313003dealation
deflation13310653deflation
degustation1345633degustation
delation92318083de_lation
denotation11311083denotation
dentations11413633dentations
dentition1049633dentition
deputation1339393deputation
desertion10410203desertion
desolation11311403desolation
destain8412083desta_i_n
destination12413843destination
detestation1248363detestation
devastation1546733devastation
deviation13312393deviation
dictation12810563dictation
dotation91412733_dotation
egestion946863eges__tion
elation73620453_e_lation
enation73419233_e_nation
equation17310483_equation
estating92614993_estating
estimation12410843_estimation
estivation1349813_estivation
fellation1238843fellation
fetations12511383fe_tations
flotation1267813flotation
forestation1447003forestation
gelatin83514733ge_lati_n
gelations102513093ge_lations
gemination131410663gemination
gemmations1545003gemmations
generation11312433generation
gestalten1042713gestalten
gestaltist1154293gestaltist
gestapo1044493gesta_po_
gestapos1153913gesta_pos
gestate83614073gestat__e
gestated102910573gestat_ed
gestates93213733gestat_es
gestatory1344523gestatory
gleization20115783gleization
gradation11107713gradation
gustative1345683gustative
guttations1145593guttations
gyration1237763g_yration
hebetation1557093hebetation
hesitations1448543hesitations
imitation11510853imitation
infestation1447043infestation
jactation1838143jactation
lactation11310813lactation
legation92412933le_gation
levitation1349443levitation
lustration1048353lustration
mediation12312293mediation
meditation13410743meditation
mentations12312583mentations
molestation1365963molestation
mutation101412883_mutation
natation81513933_natation
negation92913023ne_gation
nervation12610243nervation
nictation1189273nictation
notation81414603_notation
nutation81513103_nutation
nystatin1145093nystati_n
outstation1046163outstation
peltations12311553peltations
petition10711753pe_tition
potation101716783_potation
quotation18146973quotation
recitation12315943recitation
reflation12412333reflation
refutation1349913refutation
relation82619773re_lation
reputation12411883reputation
resection111613273resection
restating102319413restating
restationed1244373restationed
restoration11412093restoration
rotation81615453_rotation
saltation9312003saltation
sedation9312453se_dation
sensation9510583sensation
seriation9318063seriation
serration9414073serration
siltation939213siltation
statin63921473__stati_n
stations82415223__stations
substation1248993substation
temptation1446383temptation
testator847373testat_or
vegetation1448213vegetation
venation11513503ve_nation
vernation12311083vernation
vexation1838783ve_xation
visitation1348593visitation

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.533335255.2
2DLD Change Limit1486411277.73619214.2
3Display Results1271270.0602116.7
 (SQL Overall)1786911278.32921454.1
 
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.