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

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

75 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
pasteurized235311(None) 
pasteurised1452601pasteurised
pasteurize2143651pasteurize_
pasteurizer2252651pasteurizer
pasteurizes2243661pasteurizes
pasteurise1244102pasteurise_
pasteurises1343952pasteurises
pasteurizers2351762pasteurizers
unpasteurized256972unpasteurized
bacterized2446283bacte_rized
cauterized2286313caute_rized
laterized1979903la_te_rized
pasteurizing2453383pasteurizing
pastured1138233past_ur__ed
pauperized2443753paupe_rized
picturized2443683pict_urized
asteriated1177994_aste_riated
asterisked1542894_aste_risked
authorized2345224_authorized
bacterize2247654bacte_rize_
bacterizes2347964bacte_rizes
bastardized2462404bastardized
carburized2444254ca_rburized
cartelized2246174carte_lized
catechized2743474ca_techized
categorized2453714ca_tegorized
cauterize2088314caute_rize_
cauterizes2197994caute_rizes
factorized2595554fact_orized
laterize17613294la_te_rize_
laterizes18513014la_te_rizes
maderized2247024ma_de_rized
martyrized2543534mart_yrized
mastered112614004maste_r__ed
masteries111018494maste_ri_es
mesmerized2444864mesme_rized
moisturized2352504moist_urized
palletized2245454palle_tized
paltered113012484palte_r__ed
panelized2147034pa_ne_lized
pantsuited1352324pantsu_ited
parametrized26103484parametrized
passepied1442934passe_pi_ed
passerine1147084passe_rine_
passerines1246164passe_rines
pasteurising1552884pasteurising
pastored1139964past_or__ed
pastries101517424past__ri_es
pasturage1244924past_urage_
pasturages1344924past_urages
pasture9311464past_ur__e_
pasturer1037524past_ur__er
pastures10311964past_ur__es
pasturing1238434past_uri_ng
patinized2178824pa_t_inized
patronized2276064pa_tronized
pattered112714204patte_r__ed
patterned1265744patte_r_ned
pauperize2244764paupe_rize_
pauperizes2344774paupe_rizes
pestered112814964peste_r__ed
picturize2244464pict_urize_
picturizes2344564pict_urizes
plastered1288894plaste_r__ed
plasticized2594494plast_icized
postured1139494post_ur__ed
pressurized2384034pressurized
pulverized2543624pulve_rized
satirized1957894sa_t_irized
systemized2554134syste_mized
texturized2743454text_urized
wasterie111211584waste_ri_e_
wasteries121115344waste_ri_es
westernized2453524westernized
winterized2345714winte_rized

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819759.23316118.2
3Display Results75750.0302500.0
 (SQL Overall)178691759.68618448.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.