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

66 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
generalizations255714(None) 
generalisations1673621generalisations
generalization2457531generalization_
centralizations26157772centralizations
federalizations28196672federalizations
generalisation1553722generalisation_
mineralizations2677222mineralizations
centralization25108143centralization_
demoralizations27128343demoralizations
derealizations24910803dere_alizations
energizations2356183_ener_gizations
federalization2787033federalization_
lateralizations2486973lateralizations
liberalizations2675753liberalizations
literalizations2476963literalizations
mineralization2577643mineralization_
neutralizations2456423neutralizations
penalizations24511623pen__alizations
sensualizations24286193sensualizations
animalizations2548224_animalizations
canalizations24410434can__alizations
cephalizations3087594ce_phalizations
decimalizations2957574decimalizations
delocalizations27137004delocalizations
demoralization26108624demoralization_
derealization231011524dere_alization_
energization2256494_ener_gization_
equalizations3149044_e_qualizations
eternizations2258064_eter_nizations
feudalizations2756554fe_udalizations
finalizations2549254fin__alizations
generalities1347014generali__ti_es
generalizing2346344generaliz__i_ng
generations12311404gener____ations
gentrifications2175044gentrifications
germanizations26166824ge_rmanizations
globalizations2685794g_lobalizations
hebraizations27105594he_bra_izations
idealizations2379444_ide_alizations
illegalizations2564114illegalizations
lateralization2367434lateralization_
legalizations23410654__legalizations
lexicalizations33125924lexicalizations
liberalization2576064liberalization_
linearizations2355914line_arizations
literalization2397394literalization_
mongrelizations2753704mongrelizations
moralizations24410814__moralizations
nasalizations2248694__nasalizations
naturalizations2455744naturalizations
nebulizations2446674__nebulizations
neutralization2356694neutralization_
normalizations25147534__normalizations
penalization23512654pen__alization_
pluralizations2556614_pluralizations
realizations21415524__re_alizations
recanalizations2657464recanalizations
revitalizations2767624revitalizations
sensualization23226504sensualization_
serializations23710924se_rializations
sterilizations2357964_sterilizations
tenderizations2455684tender__izations
thermalizations2955174_thermalizations
vandalizations2756314van_dalizations
verbalizations2849164ve_rbalizations
vernalizations2649244ve_rnalizations

Search took 3 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 Filter178691435480.0762351197.4
2DLD Change Limit43548662.75015835.6
3Display Results66660.0461434.8
 (SQL Overall)178691662.87262218.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.