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

163 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
deflations143971(None) 
dealations11311371dealations
deflation13310651deflation_
delations102616591de_lations
reflations13311231reflations
dealation10313002dealation_
defalcations1845192defalcations
defamations1745892defamations
defecations1779002defecations
defections161510202defections
deflating142610712deflati_ng
deflators13348152deflat_ors
deflections17187322deflections
deflexions2142562deflexions
deflorations1646062deflorations
defoliations1647592defoliations
delation92318082de_lation_
deletions102610932de_letions
dentations11413632dentations
depilations14310902depilations
depletions1355742depletions
desolations12310592desolations
deviations14311162deviations
dilations102614452d_ilations
elations83719122_e_lations
fellations1338062fellations
gelations102513092ge_lations
inflations13310322inflations
reflation12412332reflation_
relations92418332re_lations
ablations11311513_ablations
acylations1547603acylations
adulations11310123adulations
aerations9317903ae_rations
alations82518893__alations
cessations1256473cessations
chelations1539073chelations
collations12312853collations
conflations16411143conflations
damnations1337083damnations
darnations1138413darnations
deaerations12311673deaerations
deceptions1547863deceptions
decimations16410163decimations
declamations1745303declamations
declarations1546803declarations
declinations15410223declinations
decoctions1547143decoctions
decollations1547363decollations
decorations14312883decorations
dedications15310873dedications
deductions1467133deductions
defalcation1746223defalcation_
defamation1646843defamation_
defeating142311973defeati_ng
defeatisms1643173defeatisms
defeatists1443423defeatists
defecation1679803defecation_
defection151610643defection_
definitions1545603definitions
deflagrations1883023deflagrations
deflaters13298703deflat_ers
deflates123013943deflat__es
deflationary1952273deflationary
deflator12328343deflat_o_r
deflection16147733deflection_
deflexion2042823deflexion_
defloration1547263defloration_
defoliation1548313defoliation_
deformations1846843deformations
deifications18410653deifications
dejections20168353dejections
delating103119603de_lati_ng
delators92314823de_lat_ors
delegations1348033delegations
deletion92011973de_letion_
delusions1037053de_lusions
demolitions1446523demolitions
demotions1258443de_motions
denegations1348543denegations
denotations1239853denotations
dentation10315243dentation_
dentitions1148853dentitions
denudations1346343denudations
depictions1546893depictions
depilation13312033depilation_
depletion1256663depletion_
deputations1448343deputations
derivations15611493derivations
derogations1349393derogations
desertions1139883desertions
desolation11311403desolation_
detections131410043detections
detentions11148803detentions
detonations1239373detonations
detractions14118273detractions
detritions1148953detritions
devaluations1646353devaluations
deviation13312393deviation_
devolutions15106263devolutions
devotions1356593de_votions
dictations1389703dictations
dilation92215463d_ilation_
dilutions10248583d_ilutions
donations101112353d_onations
dotations101411633d_otations
durations10311463d_urations
educations1339233educations
elation73620453_e_lation_
elutions82513053_e_lutions
emulations12310943emulations
enations83316903_e_nations
epilations12311713epilations
equations1839493_equations
fellation1238843fellation_
fellatios1245503fellatio_s
fetations12511383fe_tations
flatirons1244483__flatirons
gelatins93414093ge_lati_ns
gelation93014433ge_lation_
gemmations1545003gemmations
gestations1139773gestations
halations12312393_halations
ideations1039903ide__ations
illations9311393_illations
inflation12311093inflation_
isolations10310693isolations
lallations1038743lallations
legations102711923le_gations
mediations13310983mediations
mentations12312583mentations
negations102811963ne_gations
nervations1359483nervations
oblations1139373_oblations
ovulations1337973ovulations
peculations15310283peculations
peltations12311553peltations
refections151811643refections
reflating132514713reflati_ng
reflections16178553reflections
reflexions2043303reflexions
refractions16127723refractions
refutations1448673refutations
regulations12310713regulations
reinflations1546643reinflations
relation82619773re_lation_
repletions1247473repletions
restations10315843restations
revelations14410303revelations
scalations1239783scalations
sedations10311253se_dations
sensations1059853sensations
seriations10316683seriations
serrations10313093serrations
solations9814623_solations
sublations12410113sublations
sulfations13107813sulfations
ululations1037143ululations
vallations1339093vallations
venations12311723ve_nations
vernations13310333vernations
vexations1937753ve_xations
violations1337963violations

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 Limit1406031635.54625352.1
3Display Results1631630.0802037.5
 (SQL Overall)1786911636.03229623.8
 
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.