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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
generalisations167362(None) 
generalisation1553721generalisation_
generalizations2557151generalizations
generalization2457542generalization_
centralizations26157783centralizations
federalizations28196683federalizations
mineralizations2677233mineralizations
centralization25108154centralization_
demoralizations27128354demoralizations
derealizations24910814dere_alizations
energizations2356184_ener_gizations
federalization2787044federalization_
generalising1454104generalis__i_ng
generalissimos177544generalis_simos
generalists12136944generalis_t___s
generalities1347014generali__ti_es
generations12311424gener____ations
gentrifications2175044gentrifications
lateralizations2487004lateralizations
lexicalisations2492714lexicalisations
liberalizations2675764liberalizations
literalizations2476994literalizations
mineralization2577654mineralization_
neutralizations2456434neutralizations
penalizations24511634pen__alizations
sensualizations24286204sensualizations
animalizations2548255_animalizations
beneficiations21182215benefici_ations
canalizations24410435can__alizations
cephalizations3087595ce_phalizations
decimalizations2957585decimalizations
delocalizations27137005delocalizations
demoralization26108625demoralization_
denervations1657095dener___vations
deracinations1647835__deracinations
derealization231011535dere_alization_
desalinations14410185__desalinations
determinations1766895deter_minations
energization2256495_ener_gization_
enervations1478575_ener___vations
equalizations3149045_e_qualizations
eradications1549305___eradications
eternizations2258075_eter_nizations
exercitations2254565_exer_citations
externalisation2272765externalisation_
extravasations2462775_extravasations
feudalizations2756555fe_udalizations
finalizations2549255fin__alizations
generalises12167825generalis____es
generalissimo168845generalis_si_mo
generalist11169425generalis_t____
generalizing2346355generali__zi_ng
generalships1862355general_s_hi_ps
generation11312425gener____ation_
gentrification2065635gentrification_
germanizations26166835ge_rmanizations
germinations15137945g__er_minations
globalizations2685795g_lobalizations
gravitations1644765g___ravitations
hebraizations27105595he_bra_izations
idealizations2379455_ide_alizations
illegalizations2564135illegalizations
ingratiations1455155_ingrati_ations
interanimations17115195interanimations
invalidations1745625_in_validations
lateralization2367465lateralization_
legalizations23410675__legalizations
lexicalisation23102695lexicalisation_
lexicalizations33125925lexicalizations
liberalization2576075liberalization_
linearizations2355925line_arizations
literalization2397425literalization_
modernisations1752725moder_nisations
mongrelizations2753705mongrelizations
moralizations24410815__moralizations
nasalizations2248705__nasalizations
naturalizations2455765naturalizations
nebulizations2446675__nebulizations
neutralization2356705neutralization_
normalizations25147545__normalizations
penalization23512665pen__alization_
pluralizations2556615_pluralizations
realizations21415535__re_alizations
recanalizations2657465recanalizations
reevaluations1654275re_eval_uations
reexaminations23153415re_examinations
renegotiations15113375renegoti_ations
reradiations1349495__reradi_ations
retaliations12511405__retali_ations
revalidations1747115__revalidations
revitalizations2767625revitalizations
sensitisations1493625sen_sitisations
sensualization23226515sensualization_
serializations23710935se_rializations
specialisations19132425specialisations
sterilizations2357985_sterilizations
tenderizations2455695tender__izations
thermalizations2955195_thermalizations
vandalizations2756315van_dalizations
venerations14411315vener____ations
verbalizations2849175ve_rbalizations
vernalizations2649255ve_rnalizations
westernisations18172435wester_nisations

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 Limit658741034.17015797.1
3Display Results1031030.0801287.5
 (SQL Overall)1786911034.56339160.9
 
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.