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

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

76 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
presterilizing2612275(None) 
presterilize2363813presteriliz__e
presterilized2563173presteriliz_ed
presterilizes24103273presteriliz_es
restabilizing2553773_restabilizing
sterilizing2146903___sterilizing
destabilizing2653534_destabilizing
pressurizing2463854pressur__izing
rematerializing27153524_rematerializing
reutilizing2147014_reut__ilizing
sterilising1245024___sterilising
westernizing2553724_wester_nizing
aestheticizing2961895_aestheticizing
bestializing2456165_best_ializing
centralizing2458055_cent_ralizing
crystalizing2785495cryst__alizing
crystallizing2883205cryst_allizing
dematerializing28163565dematerializing
desacralizing2653875_desacralizing
dieselizing2244405dies_e__lizing
esterifying1873695__esteri_fying
eternalizing2256245__e_ternalizing
eternizing2046765__e_ter_nizing
exteriorizing3063335__exteriorizing
externalizing3054615__externalizing
federalizing2655245_fe_deralizing
fertilizing2446455_fert__ilizing
fraternizing2553405fr_ater_nizing
generalizing2346355_ge_neralizing
historicizing2862215_historicizing
immaterializing29102805immaterializing
lateralizing2257055__lateralizing
literalizing2256455__literalizing
materializing2595975__materializing
mesmerizing2544875_mesmer__izing
metricizing2545175_me_t_ricizing
neutralizing2276445_neut_ralizing
overfertilizing31101825overfertilizing
pasteurizing2453385p_aste_urizing
personalizing2575085pers_onalizing
pestering122315665p_ester____ing
pictorializing2863185p_ictorializing
plasticizing2653915plast__icizing
poeticizing2545435poe_t__icizing
predetermining2061755predeter_mining
predrilling1543675pre__dril_ling
prescribing1844555pres_cr__ibing
preselling1338695pres_e__l_ling
preserving1637365pres_er___ving
presettling1444455pres_ettl__ing
preshrinking2252445pres_hri_nking
preslicing1546365pres____licing
prespecifying2651875prespeci_fying
pressurising1573385pressur__ising
prestoring13310305prestor____ing
prestressing1583975prest_r_essing
pretelling1338135pre_te__l_ling
pretermitting1852555pre_termitting
pretraining1446505pre_t_r_aining
pretrimming1843035pre_t_ri_mming
prioritizing2453405pr__ioritizing
proselytizing2861915pros_elytizing
reenergizing2352515_reener_gizing
remobilizing2654385_re_mobilizing
reseizing19311235_res_e___izing
resensitizing2353435_resensitizing
reservicing1753425_res_er_vicing
resocializing2564595_resocializing
restraining1247535_rest_r_aining
restricting1449305_rest_ri_cting
restriking1548045_rest_r__iking
restringing1345715_rest_ri_nging
restriving1448135_rest_r__iving
serializing21149405___s_erializing
stabilizing23125535___stabilizing
westernising1653065_wester_nising

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 Filter178691950240.1231452772.4
2DLD Change Limit95024766.09615587.9
3Display Results76760.0601266.7
 (SQL Overall)178691766.27928458.5
 
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.