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

109 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
damnations133708(None) 
damnation1238401damnation_
darnations1138411darnations
adnations1039752_adnations
agnations10310032_agnations
carnations12311352carnations
darnation1039822darnation_
deaminations151010132deaminations
dominations14611042dominations
donations101112352d_onations
emanations1289592emanations
laminations1339802laminations
tarnations1038902tarnations
ablations11311513_ablations
adaptations1464573adaptations
admirations1446693admirations
admonitions1444243admonitions
adnation9310783_adnation_
adorations11310233adorations
adulations11310123adulations
aerations9317903_aerations
agnation9311723_agnation_
alations82518893_a_lations
ambitions1346343_ambitions
amnions93710913_amn__ions
amotions1069843_am_otions
aviations12311553_aviations
carnation11312943carnation_
caseations1258303caseations
cassations1276873cassations
catenations1348363catenations
caudations13108223caudations
causations1268143causations
cognations1339593cognations
conations111318903_conations
connations12312943connations
crenations12511693crenations
dalmatians1343563dalmatians
damnatory1544133damnat_ory
deaerations12311673deaerations
dealations11311373dealations
deamination14411543deamination_
defamations1745893defam_ations
deflations1439713deflations
delaminations1647943delaminations
delations102616593d_elations
demotions1258443dem_otions
dentations11413633dentations
detonations1239373detonations
deviations14311163deviations
dictations1389703dictations
dilations102614453d_ilations
diminutions1444543diminutions
divinations15128413divinations
domination13712373domination_
donation91513783d_onation_
dotations101411633d_otations
durations10311463d_urations
dynatrons1343393d_ynatrons
emanation11910783emanation_
enations83316903__enations
examinations2167463examinations
geminations14139263geminations
gemmations1545003gemmations
halations12312393ha_lations
himations1438803him_ations
jactations1936893jactations
lactations1239423lactations
lallations1038743lallations
lamentations1495983lamentations
lamination12311223lamination_
laudations1146843laudations
lavations1238973la_vations
laxations1637623la_xations
lunations9310723_lunations
marinations13411273marinations
narrations1038943narrations
natations91412493na_tations
nations74720563___nations
nominations13410533nominations
nunnations1095903nunnations
ozonations1945143ozonations
paginations1447753paginations
palmations1438733palmations
palpations1437653palpations
patinations13411003patinations
phonations1538313phonations
pinnations1236883pinnations
planations1238723planations
pronations12314033pronations
radiations11311923radiations
ruinations1039603ruinations
ruminations1349393ruminations
saltations10310623saltations
salvations1338133salvations
sanctions1138873sa_nctions
satiations10312113satiations
stagnations1244903stagnations
summations1456783summations
tarnation9310093tarnation_
taxations1636863ta_xations
urinations10310693urinations
vacations141910553va_cations
vallations1339083vallations
valuations1348783valuations
variations13310773variations
venations12311723_venations
vernations13310333vernations
zonations18139313_zonations

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.423422437.4
2DLD Change Limit1406031096.82620598.2
3Display Results1091090.0631730.2
 (SQL Overall)1786911097.31224438.0
 
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.