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

186 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
dealations1131137(None) 
dealation10313001dealation_
deflations1439711deflations
delations102616591de_lations
alations82518892__alations
deaerations12311672deaerations
defalcations1845192defalcations
defamations1745892defamations
deflation13310652deflation_
delation92318082de_lation_
deletions102610932de_letions
dentations11413632dentations
depilations14310902depilations
depletions1355742depletions
desolations12310592desolations
devaluations1646352devaluations
deviations14311162deviations
dilations102614452d_ilations
elations83719122_e_lations
fellations1338062fellations
gelations102513092ge_lations
halations12312392_halations
reflations13311232reflations
relations92418332re_lations
scalations1239782scalations
ablations11311513_ablations
acylations1547603acylations
adulations11310123adulations
aerations9317903ae_rations
alation72920553__alation_
cessations1256473cessations
chalazions24113323chalazions
chelations1539073chelations
clavations1546183clavations
coalitions1247923coalitions
collations12312853collations
dalapons1145443d_ala_pons
dalmatians1343563d_almatians
daltons8310403d_al_t_ons
damnations1337083damnations
darnations1138413darnations
deaeration11313013deaeration_
dealates92716683dealat__es
deaminations151010133deaminations
debarkations1943653debarkations
decantations1547943decantations
deceptions1547863deceptions
decimations16410163decimations
declamations1745303declamations
declarations1546803declarations
declinations15410223declinations
decoctions1547143decoctions
decollations1547363decollations
decorations14312883decorations
dedications15310873dedications
deductions1467133deductions
defalcation1746223defalcation_
defamation1646843defamation_
defecations1779003defecations
defections161510203defections
deflating142610713deflati_ng
deflators13348153deflat_ors
deflections17187323deflections
deflexions2142563deflexions
deflorations1646063deflorations
defoliations1647593defoliations
degradations1544553degradations
dejections20168353dejections
delating103119603de_lati_ng
delators92314823de_lat_ors
delegations1348033delegations
deletion92011973de_letion_
delusions1037053de_lusions
demarcations1746123demarcations
demolitions1446523demolitions
demotions1258443de_motions
denegations1348543denegations
denotations1239853denotations
dentation10315243dentation_
dentitions1148853dentitions
denudations1346343denudations
depictions1546893depictions
depilation13312033depilation_
depletion1256663depletion_
depravations1885373depravations
deputations1448343deputations
derivations15611493derivations
derogations1349393derogations
desalinations14410183desalinations
desertions1139883desertions
desolation11311403desolation_
detections131410043detections
detentions11148803detentions
detonations1239373detonations
detractions14118273detractions
detritions1148953detritions
devaluation1547073devaluation_
devastations1645823devastations
deviation13312393deviation_
devolutions15106263devolutions
devotions1356593de_votions
dictations1389703dictations
dilatations1246413dilatations
dilation92215463d_ilation_
dilutions10248583d_ilutions
divagations16103833divagations
donations101112353d_onations
dotations101411633d_otations
durations10311463d_urations
educations1339233educations
elation73620453_e_lation_
elutions82513053_e_lutions
emanations1289593emanations
emulations12310943emulations
enations83316903_e_nations
epilations12311713epilations
equations1839493_equations
escalations1347663escalations
evaluations1457323evaluations
exaltations1847293exaltations
exhalations2146023exhalations
fellation1238843fellation_
fellatios1245503fellatio_s
fetations12511383fe_tations
gelatins93414093ge_lati_ns
gelation93014433ge_lation_
gemmations1545003gemmations
gestations1139773gestations
gradations1286863gradations
halation11313853_halation_
idealizations2379453idealizations
ideations1039903ide__ations
illations9311393_illations
inflations13310323inflations
inhalations14126743inhalations
isolations10310693isolations
lallations1038743lallations
lavations1238973_lavations
laxations1637623_laxations
legations102711923le_gations
malathions1543873_malathions
mediations13310983mediations
mentations12312583mentations
natations91412493_natations
negations102811963ne_gations
nervations1359483nervations
oblations1139373_oblations
ovulations1337973ovulations
palmations1438733_palmations
palpations1437653_palpations
peculations15310283peculations
peltations12311553peltations
placations1438583placations
planations1238723planations
reactions11711713rea_ctions
realizations21415533realizations
reflation12412333reflation_
regulations12310713regulations
relation82619773re_lation_
relaxations1845643relaxations
reparations13611663reparations
repletions1247473repletions
restations10315843restations
retaliations12511403retaliations
revaluations1557633revaluations
revelations14410303revelations
saltations10310623_saltations
salvations1338133_salvations
scalation11311073scalation_
sedations10311253se_dations
sensations1059853sensations
separations1369273separations
seriations10316683seriations
serrations10313093serrations
solations9814623_solations
spallations1356103spallations
sublations12410113sublations
taxations1636863_taxations
ululations1037143ululations
vacations141910553_vacations
vallations1339083vallations
valuations1348783_valuations
venations12311723ve_nations
vernations13310333vernations
vexations1937753ve_xations
violations1337963violations

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.436409841.7
2DLD Change Limit1406031866.65621124.2
3Display Results1861860.1061754.7
 (SQL Overall)1786911867.19824825.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.