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

117 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
animations1231219(None) 
animation11313681animation_
agitations11310062agitations
animating12312502animati_ng
animatisms1446632animatisms
animatists1246882animatists
animators111210422animat_ors
aviations12311552avi_ations
himations1438802_himations
intimations13411882intimations
nidations1039212_nidations
reanimations1468782reanimations
sanitations11410842sanitations
abdications1657653abdications
ablations11311503a_blations
abnegations1444923abnegations
acclimations18146293acclimations
activations1669263activations
actuations1239293actuations
acylations1547603acylations
ademptions1543383ademptions
admirations1446693admirations
adnations1039753a_dnations
adorations11310233adorations
adulations11310123adulations
aerations9317903a_erations
affirmations2053233affirmations
affixations2443853affixations
agitation10311223agitation_
agnations10310033a_gnations
alations82518893a__lations
alienations1147883alienations
amotions1069843a__motions
angulations1268053angulations
animacies1348593animaci_es
animalian1145793animalian_
animaliers1244313animaliers
animalisms1457433animalisms
animalists1258243animalists
animalizes2148203animalizes
animaters11129973animat_ers
animates101316423animat__es
animatism1348013animati_sm
animatist11411003animati_st
animato91610623animat_o__
animator101410293animat_o_r
animatronic1552543animatronic
annexations1844263annexations
annotations1146883annotations
annulations1167833annulations
anodizations2276923anodizations
antiquations2146243antiquations
arcuations1249343arcuations
aspirations1348993aspirations
automations1348233automations
aviation11312743avi_ation_
avocations15168683avocations
capitations1549853capitations
cavitations1647843cavitations
citations11312503_citations
cremations14410713cremations
decimations16410163decimations
dilations102614453_dilations
enations83316903en__ations
epilations12311713epilations
estimations1349943estimations
fixations1936353_fixations
formations1538203formations
gemmations1545003gemmations
habitations1646883habitations
himation1339753_himation_
imitations1259963imitations
incitations13310883incitations
indications14310973indications
infixations2146693infixations
inflations13310323inflations
inhumations1666033inhumations
initiations11410723initiations
intimation12413043intimation_
invitations1449053invitations
ionizations2049893ionizations
lacrimations1645703lacrimations
laminations1339803laminations
libations112510443_libations
ligations102111993_ligations
lineations1039543lineations
marinations13411273marinations
narrations1038943narrations
natations91412493_natations
nations74720563_n__ations
navigations1545203navigations
negations102811963_negations
nictations1278313_nictations
nidation9410583_nidation_
nitrations10312033_nitrations
notations91512973_notations
novations12139003_novations
nutations91411763_nutations
oxidations1845443oxidations
paginations1447753paginations
palmations1438733palmations
patinations13411003patinations
pinnations1236883pinnations
plications14310493plications
privations15310103privations
radiations11311923radi_ations
reanimation1359633reanimation_
ruinations1039603ruinations
salivations1448733salivations
sanitation10412043sanitation_
satiations10312113sati_ations
sinuations1039413sinuations
sonications1349953sonications
summations1456783summations
urinations10310693urinations
validations1547243validations
variations13310773vari_ations

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.1561145455.1
2DLD Change Limit1406031176.92320309.5
3Display Results1171170.0601950.0
 (SQL Overall)1786911177.13925030.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.