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

115 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
etherealization2783401etherealization_
thermalization2855613_thermalization_
thermalizations2955193_thermalizations
derealization231011534__derealization_
derealizations24910814__derealizations
etherealizing2653324etherealiz__i_ng
etherization2457684ether___ization_
etherizations2557234ether___izations
externalization3164524externalization_
eternization2158675et_er__nization_
eternizations2258075et_er__nizations
etherealities1653695ethereali__ti_es
externalisation2272765externalisation_
federalization2787045feder_alization_
federalizations28196685feder_alizations
generalization2457545gener_alization_
generalizations2557155gener_alizations
internalization2455765internalization_
lateralization2367465later_alization_
lateralizations2487005later_alizations
liberalization2576075liber_alization_
liberalizations2675765liber_alizations
literalization2397425liter_alization_
literalizations2476995liter_alizations
materialization2675215materialization_
mineralization2577655miner_alization_
mineralizations2677235miner_alizations
realization20417225____realization_
realizations21415535____realizations
serialization22911725__serialization_
serializations23710935__serializations
sterilization2258865st_er_ilization_
sterilizations2357985st_er_ilizations
verbalization2769675__verbalization_
verbalizations2849175__verbalizations
vernalization25410035__vernalization_
vernalizations2649255__vernalizations
catheterization2962406cathete_rization_
centralization25108156centr_alization_
centralizations26157786centr_alizations
cephalization2988186__cephalization_
cephalizations3087596__cephalizations
creolization2348816___creolization_
creolizations2457886___creolizations
demoralization26108626demor_alization_
demoralizations27128356demor_alizations
desacralization2754176desacr_alization_
desexualization3263446desexualization_
detribalization2754276det_ribalization_
dieselization2356056_diese_lization_
dieselizations2455916_diese_lizations
energization2256496e_ner__gization_
energizations2356186e_ner__gizations
epithelization28113886epithe_lization_
epithelizations29103536epithe_lizations
equalization3049816___equalization_
equalizations3149046___equalizations
eternalizing2256246et_ernaliz__i_ng
ethereality1753166ethereali__t___y
etherealize2354046etherealiz_____e
etherealized2553356etherealiz____ed
etherealizes2453756etherealiz____es
evangelization27143316evange_lization_
evangelizations28112856evange_lizations
exteriorization3173076exteriorization_
fertilization2588456__fertilization_
fertilizations26137896__fertilizations
feudalization2657066__feudalization_
feudalizations2756556__feudalizations
formalization27137726__formalization_
formalizations28146986__formalizations
generalisation1553726gener_alisation_
generalisations1673626gener_alisations
germanization25137196__germanization_
germanizations26166836__germanizations
hebraization26126146__hebra_ization_
hebraizations27105596__hebra_izations
hypersalivation2662156hypersalivation_
idealization22410276___idealization_
idealizations2379456___idealizations
illegalization2454316ille_galization_
illegalizations2564136ille_galizations
immortalization2862766immortalization_
legalization22411616__le_galization_
legalizations23410676__le_galizations
mathematization3182816mathe_matization_
mongrelization2653736mongre_lization_
mongrelizations2753706mongre_lizations
moralization23411616__mor_alization_
moralizations24410816__mor_alizations
naturalization2356126natur_alization_
naturalizations2455766natur_alizations
neutralization2356706neutr_alization_
neutralizations2456436neutr_alizations
normalization24138296__normalization_
normalizations25147546__normalizations
penalization23512666__pe_nalization_
penalizations24511636__pe_nalizations
pluralization2457086_plur_alization_
pluralizations2556616_plur_alizations
schematization3063736sche_matization_
schematizations3173396sche_matizations
specialization27106286_specialization_
specializations28115636_specializations
terrorization2256666_t_errorization_
terrorizations2356176_t_errorizations
tetanization21410306_t_e_tanization_
tetanizations2249916_t_e_tanizations
theorization2456766_th__eorization_
theorizations2576166_th__eorizations
thermalizing2754936_thermaliz__i_ng
trivialization2664816_trivialization_
trivializations2754486_trivializations
weatherization2954146weather___ization_
weatherizations3054076weather___izations

Search took 6 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 Limit658741154.98313219.7
3Display Results1151150.0801437.5
 (SQL Overall)1786911155.37633238.7
 
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.