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

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

72 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
crystallization2962241crystallization_
crystallizing2883204crystalliz__i_ng
brutalization24137265br_uta_lization_
brutalizations25146865br_uta_lizations
capitalization2756195capita_lization_
capitalizations2856055capita_lizations
crystalizing2785495crysta_liz__i_ng
crystallinities2071595crystalliniti_es
crystallising1982835crystalli__si_ng
crystallizable3071655crystalliza__ble
metallization24176865__metallization_
metallizations25126505__metallizations
bastardization26143086_bastardization_
bastardizations27112876_bastardizations
canalization23411166c__ana_lization_
canalizations24410436c__ana_lizations
cartelization2456996c_art_elization_
cartelizations2556556c_art_elizations
centralization25108156c_entralization_
centralizations26157786c_entralizations
cephalization2988186c_epha_lization_
cephalizations3087596c_epha_lizations
constellation1554796constell__ation_
constellations1654406constell__ations
creolization2348816cr___eolization_
creolizations2457886cr___eolizations
criminalization2863196criminalization_
crystalline16154566crystall____i_ne
crystallinity2172206crystalli__ni_ty
crystallite16134506crystalli__t___e
crystallites17143906crystalli__t__es
crystallize25134236crystalliz_____e
crystallized27123756crystalliz____ed
crystallizer26133516crystalliz____er
crystallizers27182896crystalliz___ers
crystallizes26134106crystalliz____es
cyclization2746416c_y___clization_
cyclizations2845756c_y___clizations
destabilization2763336_destabilization_
digitalization2586366digita_lization_
digitalizations2686186digita_lizations
installation1254906_install__ation_
installations1354226_install__ations
nasalization2149386_nas_a_lization_
nasalizations2248706_nas_a_lizations
palatalization2565256palata_lization_
palatalizations2655046palata_lizations
realization20417226_r__ea_lization_
realizations21415536_r__ea_lizations
recrystallizing3071796recrystalliz__i_ng
retaliation11612326_r_eta_li_ation_
retaliations12511406_r_eta_li_ations
reutilization2249196_reut_ilization_
reutilizations2348716_reut_ilizations
revitalization2667806revita_lization_
revitalizations2767626revita_lizations
ritualization2258536_r_itualization_
ritualizations2357986_r_itualizations
sensualization23226516sensua_lization_
sensualizations24286206sensua_lizations
stabilization2466196___stabilization_
stabilizations2565606___stabilizations
stylization2346676___st_ylization_
stylizations2445936___st_ylizations
systemization2774476_syst_emization_
systemizations2864086_syst_emizations
trivialization2664816trivia_lization_
trivializations2754486trivia_lizations
visualization2557936_visua_lization_
visualizations2657396_visua_lizations
vitalization24410976__vita_lization_
vitalizations25410326__vita_lizations

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 Limit65874724.28015391.1
3Display Results72720.0631142.9
 (SQL Overall)178691724.65638378.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.