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 “clavations” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
clavations154618(None) 
clavation1447001clavation_
lavations1238971_lavations
elevations1338632elevations
lavation1139972_lavation_
laxations1637622_laxations
placations1438582placations
planations1238722planations
salvations1338132salvations
acclamations18164043acclamations
activations1669263activations
alations82518893__alations
aviations12311553__aviations
bloviations1643753bloviations
captions123813223c_a_ptions
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
cations94524143c___ations
caudations13108223caudations
causations1268143causations
cautions103313183c_a_utions
cavatina1347333c_avati_na
cavatinas1444783c_avatinas
cavatine13310323c_avati_ne
cavitations1647843c_avitations
cessations1256473cessations
chalazions24113323chalazions
chelations1539073chelations
ciliations121111003ciliations
citations11312503c_itations
clarions10310493cl__arions
coactions1349743coa_ctions
coalitions1247923coalitions
coaptations1547543coaptations
cognations1339593cognations
collations12312853collations
colorations13911893colorations
conations111318903c_onations
connations12312943connations
creations112614543c_reations
cremations14410713cremations
crenations12511693crenations
cultivations1745593cultivations
dealations11311373dealations
declamations1745303declamations
declarations1546803declarations
dilatations1246413dilatations
elations83719123el__ations
elevation1239233elevation_
eluviations14115793eluviations
emanations1289593emanations
excavations2345083excavations
exclamations23104103exclamations
floatations1444103floatations
flotations1366873flotations
glaciations1445963glaciations
gradations1286863gradations
halations12312393_halations
illations9311393il_lations
lactations1239423_lactations
lallations1038743_lallations
laudations1146843_laudations
laxation1538423_laxation_
legations102711923_legations
libations112510443_libations
ligations102111993_ligations
lobations11219613_lobations
locations112512743_locations
lunations9310723_lunations
luxations1637273_luxations
natations91412493_natations
nervations1359483nervations
novations12139003_novations
ovations11149263__ovations
palmations1438733palmations
palpations1437653palpations
placation1339773placation_
planation11310123planation_
plantations1347473plantations
plications14310493plications
privations15310103privations
reclamations1645713reclamations
relaxations1845643relaxations
salivations1448733salivations
saltations10310623saltations
salvation1239293salvation_
scalations1239783scalations
solvations1336833solvations
starvations1445053starvations
taxations1636863_taxations
ululations1037143ululations
vacations141910553_vacations
vallations1339083vallations
valuations1348783valuations

Search took 7 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.406440125.6
2DLD Change Limit140603955.64024929.6
3Display Results95950.0462065.2
 (SQL Overall)178691956.09229332.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.