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

122 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
gestations113977(None) 
gestation10310661gestation_
gustations1147231gustations
restations10315841restations
cessations1256472cessations
dentations11413632dentations
fetations12511382fe_tations
gelations102513092ge_lations
gemmations1545002gemmations
gestating11229982gestati_ng
gestational1245112gestational
gustation1047962gustation_
guttations1145592guttations
hesitations1448542hesitations
mentations12312582mentations
peltations12311552peltations
restation9316912restation_
stations82415222__stations
aerations9317903ae_rations
aestivations1547483aestivations
agitations11310063agitations
attestations1244463attestations
betatrons1145083be_tatrons
caseations1258303caseations
cassations1276873cassations
castrations13410053castrations
cessation1176853cessation_
citations11312503_citations
dealations11311373dealations
deflations1439713deflations
degustations1444833degustations
delations102616593de_lations
denotations1239853denotations
dentation10315243dentation_
dentitions1148853dentitions
deputations1448343deputations
desertions1139883desertions
desolations12310593desolations
destains9311813desta_i_ns
destinations13412663destinations
detestations1347583detestations
devastations1645823devastations
deviations14311163deviations
dictations1389703dictations
dotations101411633_dotations
egestions1046703eges__tions
elations83719123_e_lations
enations83316903_e_nations
equations1839493_equations
estating92614993_estati_ng
estimations1349943_estimations
estivations1449273_estivations
fellations1338063fellations
fetation11613143fe_tation_
flotations1366873flotations
forestations1546323forestations
gelatins93414093ge_lati_ns
gelation93014433ge_lation_
geminations14139263geminations
gemmation1445963gemmation_
generations12311423generations
gestaltists1252423gestaltists
gestapos1153913gesta_po_s
gestates93213733gestat__es
gestative1347303gestati_ve
gestatory1344523gestat_ory
gleizations21135283gleizations
gradations1286863gradations
guttation1046173guttation_
gyrations1336923g_yrations
hebetations1656463hebetations
hesitation1349633hesitation_
imitations1259963imitations
infestations1546623infestations
jactations1936893jactations
lactations1239423lactations
legations102711923le_gations
levitations1448293levitations
lustrations1147623lustrations
mediations13310983mediations
meditations1449333meditations
mentation11313983mentation_
molestations1475473molestations
mutations111211453_mutations
natations91412493_natations
negations102811963ne_gations
nervations1359483nervations
nictations1278313nictations
notations91512973_notations
nutations91411763_nutations
nystatins1244753nystati_ns
outstations1145343outstations
peltation11312963peltation_
petitions11511083pe_titions
potations111615073_potations
quotations19146283quotations
recitations13314203recitations
reflations13311233reflations
refutations1448673refutations
relations92418333re_lations
reputations13410733reputations
resections121513033resections
restating102319413restati_ng
restationed1244373restationed
restorations12410953restorations
rotations91613843_rotations
saltations10310623saltations
sedations10311253se_dations
sensations1059853sensations
seriations10316683seriations
serrations10313093serrations
siltations1038553siltations
statins73719773__stati_ns
station72717243__station_
substations1348243substations
temptations1545413temptations
testators947333testat_ors
vegetations1547323vegetations
venations12311723ve_nations
vernations13310333vernations
vexations1937753ve_xations
visitations1447673visitations

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 Filter1786911406030.403443402.0
2DLD Change Limit1406031226.53321522.0
3Display Results1221220.0631936.5
 (SQL Overall)1786911226.99925530.9
 
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.