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 “vandalizations” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
vandalizations275631(None) 
vandalization2656731vandalization_
canalizations24410432can_alizations
aldolizations2346343_aldolizations
analyzations2463663_an_alyzations
animalizations2548253_animalizations
canalization23411163can_alization_
evangelizations28112853evangelizations
feudalizations2756553feudalizations
finalizations2549253fin_alizations
labializations2547873labializations
nasalizations2248703na_salizations
penalizations24511633pen_alizations
randomizations2653683randomizations
verbalizations2849173verbalizations
vernalizations2649253vernalizations
visualizations2657393visualizations
vitalizations25410323v_italizations
vocalizations2749273v_ocalizations
actualizations25126964actualizations
aldolization2246734_aldolization_
analyzation2354384_an_alyzation_
animalization2448894_animalization_
anodizations2276924_an_odizations
balkanizations2963984balkanizations
barbarizations27115444barbarizations
brutalizations25146864brutalizations
canonizations2447244can_onizations
capitalizations2856054capitalizations
cartelizations2556554cartelizations
centralizations26157784centralizations
cephalizations3087594cephalizations
channelizations2962324channelizations
dandifications2145434dandifications
derealizations24910814derealizations
equalizations3149044_equalizations
evangelization27143314evangelization_
feudalization2657064feudalization_
finalization2459924fin_alization_
focalizations2748994_focalizations
formalizations28146984formalizations
galvanizations27224454galvanizations
generalizations2557154generalizations
globalizations2685794globalizations
idealizations2379454_idealizations
idolizations2247464__idolizations
invalidations1745624_invalidations
labialization2458344labialization_
lateralizations2487004lateralizations
legalizations23410674_legalizations
linearizations2355924linearizations
localizations2449794_localizations
mineralizations2677234mineralizations
moralizations24410814_moralizations
mutualizations2556374mutualizations
nasalization2149384na_salization_
naturalizations2455764naturalizations
normalizations25147544normalizations
palatalizations2655044palatalizations
paralyzations2783414pa_ralyzations
penalization23512664pen_alization_
pluralizations2556614pluralizations
radicalizations27125764radicalizations
randomization2563864randomization_
realizations21415534__realizations
recanalizations2657464recan_alizations
ritualizations2357984ritualizations
sanitizations2248554san_itizations
sensualizations24286204sensualizations
serializations23710934serializations
signalizations2456734signalizations
socializations2548484socializations
tenderizations2455694tenderizations
validations1547244v___alidations
valorizations2597794va_lorizations
vandalizing2545374vandaliz__i_ng
vaporizations2776964va_porizations
velarizations2549274v_elarizations
verbalization2769674verbalization_
vernalization25410034vernalization_
vindications1845684vind__ications
visualization2557934visualization_
vitalization24410974v_italization_
vocalization2649994v_ocalization_
vulcanizations2864404vulcanizations
vulgarizations2754564vulgarizations

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874864.01616402.9
3Display Results86860.0631365.1
 (SQL Overall)178691864.39240685.6
 
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.