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

60 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
pasteurizer225266(None) 
pasteurize2143661pasteurize_
pasteurized2353111pasteurized
pasteurizers2351771pasteurizers
pasteurizes2243671pasteurizes
pasteurise1244122pasteurise_
pasteurised1452602pasteurised
pasteurises1343962pasteurises
pasteurizing2453393pasteurizing
pasturer1037523past_ur__er
unpasteurized256973unpasteurized
authorizer2244544_authorizer
bacterize2247674bacte_rize_
bacterized2446314bacte_rized
bacterizes2347984bacte_rizes
catechizer2643154ca_techizer
cauterize2088324caute_rize_
cauterized2286334caute_rized
cauterizes2198004caute_rizes
easterner945064easte_r_ner
laterize17613314la_te_rize_
laterized1979934la_te_rized
laterizes18513034la_te_rizes
masteries111018514maste_ri_es
mesmerizer2344094mesme_rizer
moisturizer2252074moist_urizer
palletizer2184374palle_tizer
palterer102411294palte_r__er
paltrier1037544palt__ri_er
passerine1147084passe_rine_
passerines1246164passe_rines
pasteurising1552894pasteurising
pastier94320384past___i_er
pastries101517424past__ri_es
pasturage1244924past_urage_
pasturages1344924past_urages
pasture9311464past_ur__e_
pastured1138234past_ur__ed
pasturers1136394past_ur__ers
pastures10311964past_ur__es
pasturing1238434past_uri_ng
patterer103112184patte_r__er
pauperize2244764paupe_rize_
pauperized2443754paupe_rized
pauperizes2344774paupe_rizes
pesterer102412714peste_r__er
picturize2244464pict_urize_
picturized2443684pict_urized
picturizes2344564pict_urizes
plasterer1178114plaste_r__er
plasticizer2493894plast_icizer
posterior1147854poste_ri_or
postrider1246654post__rider
posturer1038924post_ur__er
pressurizer2263444pressurizer
pulverizer2443204pulve_rizer
satirizer1846464sa_t_irizer
wasterie111211594waste_ri_e_
wasteries121115364waste_ri_es
waterier11312104wa_te_ri_er

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.420425454.8
2DLD Change Limit148819609.47015714.8
3Display Results60600.0331818.2
 (SQL Overall)178691609.92318007.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.