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

123 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
animation1131368(None) 
animations12312191animations
agitation10311222agitation
animalian1145792animalian
animating12312502animating
animatism1348012animatism
animatist11411002animatist
animato91610622animat_o_
animator101410292animat_or
aviation11312742avi_ation
himation1339752_himation
intimation12413042intimation
nidation9410582_nidation
reanimation1359632reanimation
sanitation10412042sanitation
abdication1548223abdication
ablation10312433a_blation
abnegation1345413abnegation
acclimation17127093acclimation
activation15610133activation
actuation11310333actuation
acylation1448653acylation
ademption1443493ademption
admiration1347733admiration
adnation9310783a_dnation
adoration10311313adoration
adulation10311013adulation
aeration8319933a_eration
affirmation1953683affirmation
affixation2344393affixation
agitations11310063agitations
agnation9311723a_gnation
alation72920553a__lation
alienation1048793alienation
amotion9710473a__motion
angulation1149553angulation
animacies1348593animacies
animalic1258153animali_c
animalier1145933animalier
animalism1358613animalism
animalist11511643animalist
animality1447803animality
animalize2048553animalize
animate91617213animat__e
animated111612373animat_ed
animately1445123animately
animater101512393animat_er
animaters11129973animaters
animates101316423animat_es
animatisms1446633animatisms
animatists1246883animatists
animators111210423animators
animatronic1552543animatronic
annexation1744953annexation
annotation1047753annotation
annulation1068953annulation
anodization2187643anodization
antiquation2047423antiquation
arcuation11410583arcuation
aspiration1249993aspiration
automation1249143automation
aviations12311553avi_ations
avocation14168993avocation
capitation14311363capitation
cavitation1549133cavitation
citation10314363_citation
cremation13511643cremation
decimation15411623decimation
dilation92215463_dilation
enation73419233en__ation
epilation11312963epilation
estimation12410843estimation
fixation1837073_fixation
formation1439423formation
gemmation1445963gemmation
habitation1547913habitation
himations1438803_himations
imitation11510853imitation
incitation12312223incitation
indication13312033indication
infixation2047533infixation
inflation12311093inflation
inhumation1567053inhumation
initiation10412103initiation
intimations13411883intimations
invitation13410023invitation
ionization19411273ionization
lacrimation1546263lacrimation
lamination12311223lamination
libation102411363_libation
ligation92313093_ligation
lineation9310763lineation
marination12312813marination
narration9310063narration
natation81513933_natation
nation64322803_n__ation
navigation1446003navigation
negation92913023_negation
nictation1189273_nictation
nidations1039213_nidations
nitration9313443_nitration
notation81414603_notation
novation111710013_novation
nutation81513103_nutation
oxidation1746323oxidation
pagination1348993pagination
palmation13310223palmation
patination12312573patination
pinnation1138013pinnation
plication13311683plication
privation14311173privation
radiation10313393radi_ation
reanimations1468783reanimations
ruination9311273ruination
salivation1349813salivation
sanitations11410843sanitations
satiation9313433sati_ation
sinuation9310413sinuation
sonication12411183sonication
summation1347803summation
urination9312173urination
validation1448413validation
variation12312393vari_ation

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.423422437.4
2DLD Change Limit1486411237.07621006.4
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.56223630.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.