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
pasteurizer225265(None) 
pasteurize2143651pasteurize_
pasteurized2353111pasteurized
pasteurizers2351761pasteurizers
pasteurizes2243661pasteurizes
pasteurise1244102pasteurise_
pasteurised1452602pasteurised
pasteurises1343952pasteurises
pasteurizing2453383pasteurizing
pasturer1037523past_ur__er
unpasteurized256973unpasteurized
authorizer2244544_authorizer
bacterize2247654bacte_rize_
bacterized2446284bacte_rized
bacterizes2347964bacte_rizes
catechizer2643144ca_techizer
cauterize2088314caute_rize_
cauterized2286314caute_rized
cauterizes2197994caute_rizes
easterner945054easte_r_ner
laterize17613294la_te_rize_
laterized1979904la_te_rized
laterizes18513014la_te_rizes
masteries111018494maste_ri_es
mesmerizer2344094mesme_rizer
moisturizer2252074moist_urizer
palletizer2184364palle_tizer
palterer102411274palte_r__er
paltrier1037524palt__ri_er
passerine1147084passe_rine_
passerines1246164passe_rines
pasteurising1552884pasteurising
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
patterer103112174patte_r__er
pauperize2244764paupe_rize_
pauperized2443754paupe_rized
pauperizes2344774paupe_rizes
pesterer102412704peste_r__er
picturize2244464pict_urize_
picturized2443684pict_urized
picturizes2344564pict_urizes
plasterer1178104plaste_r__er
plasticizer2493894plast_icizer
posterior1147834poste_ri_or
postrider1246654post__rider
posturer1038924post_ur__er
pressurizer2263444pressurizer
pulverizer2443204pulve_rizer
satirizer1846464sa_t_irizer
wasterie111211584waste_ri_e_
wasteries121115344waste_ri_es
waterier11312084wa_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.436409841.7
2DLD Change Limit148819609.45315743.0
3Display Results60600.0331818.2
 (SQL Overall)178691609.92218009.6
 
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.