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

113 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
weatherizations3054061weatherizations_
weatherization2954132weatherization__
etherizations2557223_e_therizations_
etherization2457674_e_therization__
laterizations22410054_lat_erizations_
westernizations27154114west_ernizations_
winterizations26157484wint_erizations_
authorizations2655085_authorizations_
bacterizations2766645_bacterizations_
cauterizations25197135_cauterizations_
epithelizations29103525epithelizations_
eternizations2258065_e_t_ernizations_
fraternizations27153745frat_ernizations_
laterization21410665_lat_erization__
mercerizations2756085me_rcerizations_
reauthorization2762315reauthorization__
tenderizations2455675te_nderizations_
theorizations2576125___theorizations_
weatherizing2854355weatheriz__i_n_g
westernisations18172425west_ernisations_
westernization26134465west_ernization__
winterization25137795wint_erization__
arborizations2447406__arborizations_
atomizations2348456__at_omizations_
authorization2555846_authorization__
bacterization26107196_bacterization__
barbarizations27115446_barbarizations_
beatifications21157466beat_ifications_
botherations1754166_bother__ations_
bowdlerizations3062406bowdlerizations_
carburizations2754126_carburizations_
cartelizations2556546_cartelizations_
catechizations3053526_catechizations_
categorizations27103866_categorizations_
catheterization2962396_catheterization__
cauterization24187736_cauterization__
centralizations26157776centralizations_
cephalizations3087596ce_phalizations_
channelizations2962326channelizations_
cicatrizations2794906cicat__rizations_
deaerations12311666dea__er__ations_
decolorizations27136096decolorizations_
demonetizations2755706demonetizations_
deodorizations2556296de_odorizations_
depolarizations27146326depolarizations_
deteriorations15164676de_t_eriorations_
determinations1766886de_t_erminations_
deuterations1348076deut_er__ations_
dimerizations2548526__dimerizations_
energizations2356186_e__nergizations_
epithelization28113876epithelization__
eternization2158666_e_t_ernization__
evangelizations28112856evangelizations_
exterminations2365126_ext_erminations_
extrications2149046_ext__rications_
factorizations2855746_factorizations_
featherbrains21132246featherbra_i_ns_
fertilizations26137896fert_ilizations_
fiberizations27136346__fiberizations_
fraternization26174056frat_ernization__
gelatinizations2554086gelat_inizations_
geometrizations2753416geometrizations_
glamorizations2664576gla_morizations_
graphitizations3062296graphitizations_
hellenizations2654326he_llenizations_
isomerizations2555126_isomerizations_
itemizations2347816__it_emizations_
keratinizations2853866kerat_inizations_
lateralizations2486976_lat_eralizations_
latinizations22159016_lat_inizations_
magnetizations2654266_magnetizations_
martyrizations2854476_martyrizations_
mechanizations3055816me_chanizations_
memorizations2649506me__morizations_
mercerization2656316me_rcerization__
metallizations25126506me_tallizations_
metrications1649816me_t__rications_
motorizations2449086_mot_orizations_
neutralizations2456426neutralizations_
notarizations2248776_not_arizations_
palletizations25105006_palletizations_
pasteurizations2673986pasteurizations_
patronizations2576186_patronizations_
pelletizations25105026pe_lletizations_
picturizations2764666pict_urizations_
polymerizations31103956polymerizations_
pulverizations28104486_pulverizations_
racemizations2665466_ra_cemizations_
realizations21415526rea___lizations_
reattributions16112426reat_tributions_
regularizations2564886regularizations_
reiterations12410856reit_er__ations_
remonetizations2655766remonetizations_
repatriations15136516repat__ri_ations_
repolarizations26136166repolarizations_
reutilizations2348716reut_ilizations_
revalorizations2754556revalorizations_
rhythmizations3461716rhyth_mizations_
scatterations1552526scatter__ations_
secularizations2675376secularizations_
suberizations2468756__suberizations_
systemizations2864056syst_emizations_
temporizations2785736te_mporizations_
tenderization2355726te_nderization__
terrorizations2356166te_rrorizations_
tetanizations2249896te_t_anizations_
theorization2456756___theorization__
valorizations2597776_va_lorizations_
vaporizations2776946_va_porizations_
velarizations2549266ve__larizations_
weatherizes2645936weatheriz____es_
weatherpersons2271586weather_persons_
westernisation17152566west_ernisation__

Search took 8 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.1101624463.6
2DLD Change Limit658741136.8769580.3
3Display Results1131130.156724.4
 (SQL Overall)1786911137.14225019.7
 
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.