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

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

104 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
generalisations1673621generalisations_
generalisation1553722generalisation__
generalizations2557152generalizations_
generalization2457543generalization__
centralizations26157784centralizations_
federalizations28196684federalizations_
mineralizations2677234mineralizations_
centralization25108155centralization__
demoralizations27128355demoralizations_
derealizations24910815dere_alizations_
energizations2356185_ener_gizations_
federalization2787045federalization__
generalising1454105generalis__i_n_g
generalissimos177545generalis_simos_
generalists12136945generalis_t___s_
generalities1347015generali__ti_es_
generations12311425gener____ations_
gentrifications2175045gentrifications_
lateralizations2487005lateralizations_
lexicalisations2492715lexicalisations_
liberalizations2675765liberalizations_
literalizations2476995literalizations_
mineralization2577655mineralization__
neutralizations2456435neutralizations_
penalizations24511635pen__alizations_
sensualizations24286205sensualizations_
animalizations2548256_animalizations_
beneficiations21182216benefici_ations_
canalizations24410436can__alizations_
cephalizations3087596ce_phalizations_
decimalizations2957586decimalizations_
delocalizations27137006delocalizations_
demoralization26108626demoralization__
denervations1657096dener___vations_
deracinations1647836__deracinations_
derealization231011536dere_alization__
desalinations14410186__desalinations_
determinations1766896deter_minations_
energization2256496_ener_gization__
enervations1478576_ener___vations_
equalizations3149046_e_qualizations_
eradications1549306___eradications_
eternizations2258076_eter_nizations_
exercitations2254566_exer_citations_
externalisation2272766externalisation__
extravasations2462776_extravasations_
feudalizations2756556fe_udalizations_
finalizations2549256fin__alizations_
generalises12167826generalis____es_
generalissimo168846generalis_si__mo
generalist11169426generalis_t_____
generalizing2346356generali__zi_n_g
generalships1862356general_s_hi_ps_
generation11312426gener____ation__
generational1354826gener____ational
gentrification2065636gentrification__
germanizations26166836ge_rmanizations_
germinations15137946g__er_minations_
globalizations2685796g_lobalizations_
gravitations1644766g___ravitations_
hebraizations27105596he_bra_izations_
idealizations2379456_ide_alizations_
illegalizations2564136illegalizations_
ingratiations1455156_ingrati_ations_
interanimations17115196interanimations_
invalidations1745626_in_validations_
lateralization2367466lateralization__
legalizations23410676__legalizations_
lexicalisation23102696lexicalisation__
lexicalizations33125926lexicalizations_
liberalization2576076liberalization__
linearizations2355926line_arizations_
literalization2397426literalization__
modernisations1752726moder_nisations_
mongrelizations2753706mongrelizations_
moralizations24410816__moralizations_
nasalizations2248706__nasalizations_
naturalizations2455766naturalizations_
nebulizations2446676__nebulizations_
neutralization2356706neutralization__
normalizations25147546__normalizations_
penalization23512666pen__alization__
pluralizations2556616_pluralizations_
realizations21415536__re_alizations_
recanalizations2657466recanalizations_
reevaluations1654276re_eval_uations_
reexaminations23153416re_examinations_
renegotiations15113376renegoti_ations_
reradiations1349496__reradi_ations_
retaliations12511406__retali_ations_
revalidations1747116__revalidations_
revitalizations2767626revitalizations_
sensitisations1493626sen_sitisations_
sensualization23226516sensualization__
serializations23710936se_rializations_
specialisations19132426specialisations_
sterilizations2357986_sterilizations_
tenderizations2455696tender__izations_
thermalizations2955196_thermalizations_
vandalizations2756316van_dalizations_
venerations14411316vener____ations_
verbalizations2849176ve_rbalizations_
vernalizations2649256ve_rnalizations_
westernisations18172436wester_nisations_

Search took 7 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.373479064.3
2DLD Change Limit658741046.25010539.8
3Display Results1041040.0801300.0
 (SQL Overall)1786911046.70326658.4
 
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.