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

126 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
adoration1031131(None) 
adorations11310231adorations
abortion1048102abor_tion
adjuration1845522adjuration
admiration1347732admiration
adnation9310782ad_nation
adoption1146082ado_ption
adsorption1344272adsorption
adulation10311012adulation
advocation1645742advocation
aeration8319932a_eration
avocation14168992avocation
donation91513782_donation
dotation91412732_dotation
duration9312692_duration
oration71617712__oration
proration11415982proration
abdication1548223abdication
aberration1267203aberration
abjuration1945883abjuration
ablation10312433a_blation
abolition1147053abolition
abortions1147783abor_tions
abrasion1046623a_brasion
abrogation13107333abrogation
absorption1444883absorption
accretion1345933accretion
actuation11310333actuation
acylation1448653acylation
adaptation1355223adaptation
adaption1145643ad_aption
addiction13146013addiction
addition1096893ad_dition
adduction13225163adduction
ademption1443493ademption
adjurations1944823adjurations
admirations1446693admirations
admonition1344443admonition
adnations1039753ad_nations
adoptions1245783ado_ptions
adsorptions1444163adsorptions
adulations11310123adulations
adumbration1652613adumbration
advection1545553advection
advocations1755413advocations
aerations9317903a_erations
agitation10311223agitation
agnation9311723a_gnation
alation72920553a__lation
allocation1248573allocation
alteration10612903alteration
amotion9710473amo__tion
animation11313683animation
annotation1047753annotation
apportion1347003appor_tion
arcuation11410583arcuation
arrogation11107443arrogation
aspiration1249993aspiration
attraction1276953attraction
attrition966963attrition
automation1249143automation
aviation11312743a_viation
avocations15168683avocations
castration12410803castration
coloration12913183coloration
conation101420883_conation
damnation1238403damnation
darnation1039823darnation
decoration13314423decoration
delation92318083_delation
dilation92215463_dilation
donations101112353_donations
dotations101411633_dotations
durations10311463_durations
education12310203education
elaboration1345743elaboration
evaporation1645553evaporation
evocation142010293evocation
federation1449573federation
floriation1367793floriation
flotation1267813flotation
formation1439423_formation
gyration1237763_gyration
hydration1646073hydration
ideation9310493id_eation
induration11410613induration
iodation9310383_iodation
isolation9311643isolation
iteration9515033iteration
laceration1249573laceration
libration111510163libration
lobation102110553_lobation
location102113913_location
maceration1449613maceration
maturation1249513maturation
migration12179703migration
moderation1348653moderation
narration9310063narration
nitration9313443nitration
notation81414603_notation
novation111710013_novation
operation11314003operation
orations81515803__orations
ovation101510023__ovation
ozonation1845673ozonation
peroration12316003peroration
phonation1439393phonation
portion9615493_por_tion
potation101716783_potation
probation13412183probation
pronation11415703pronation
prorations12314463prorations
quotation18146973quotation
radiation10313393rad_iation
ration64226013___ration
rogation91612053_rogation
rotation81615453_rotation
saturation1049803saturation
serration9414063serration
solation8916153_solation
sorption1037513_sorption
titration9310543titration
vibration14138203vibration
violation1238443violation
vocation132311983_vocation
zonation171410723_zonation

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411267.45319943.8
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.67223291.3
 
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.