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

74 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
pasteurised145260(None) 
pasteurise1244101pasteurise_
pasteurises1343951pasteurises
pasteurized2353111pasteurized
pasteurize2143652pasteurize_
pasteurizer2252652pasteurizer
pasteurizes2243662pasteurizes
asterisked1542893_aste_risked
pasteurising1552883pasteurising
pasteurizers2351763pasteurizers
pastured1138233past_ur__ed
unpasteurized256973unpasteurized
aspersed11428294_aspe_r_sed
asteriated1177994_aste_riated
asterisk1248674_aste_ris_k
asterisks1346814_aste_risks
asterism10413254_aste_ris_m
asterisms11511064_aste_risms
auteurism1144614_auteuris_m
auteurisms1244084_auteurisms
auteurist946784_auteuris_t
auteurists1045094_auteurists
authorised1444514_authorised
bacterized2446294bacte_rized
bastardised1572284bastardised
carburised1543984ca_rburised
cartelised1344914carte_lised
catechised1843114ca_techised
categorised1553284ca_tegorised
cauterized2286314caute_rized
laterized1979914la_te_rized
mastered112614004maste_r__ed
masteries111018494maste_ri_es
mesmerised1543874mesme_rised
moisturised1452294moist_urised
palletised1344514palle_tised
paltered113012494palte_r__ed
pantsuited1352324pantsu_ited
passepied1442934passe_pi_ed
passerine1147084passe_rine_
passerines1246164passe_rines
pastelist1149624paste_lis_t
pastelists1245794paste_lists
pastellist1255574pastellis_t
pastellists1353284pastellists
pasterns104112624paste_rns__
pasters94531734paste_r_s__
pasteups1243494pasteu_ps__
pasteurizing2453384pasteurizing
pastises103616054past___ises
pastored1139974past_or__ed
pastries101517424past__ri_es
pasturage1244924past_urage_
pasturages1344924past_urages
pasture9311464past_ur__e_
pasturer1037524past_ur__er
pastures10311964past_ur__es
pasturing1238434past_uri_ng
patronised1395034pa_tronised
pattered112714204patte_r__ed
patterned1265744patte_r_ned
pauperized2443754paupe_rized
pestered112814974peste_r__ed
picturized2443684pict_urized
plastered1288904plaste_r__ed
postured1139494post_ur__ed
posturist11410444post_uris_t
posturists1247074post_urists
pressurised1463824pressurised
pulverised1643094pulve_rised
satirised1046554sa_t_irised
wasterie111211584waste_ri_e_
wasteries121115344waste_ri_es
westernised1552914westernised

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 Limit148819749.00316529.9
3Display Results74740.0302466.7
 (SQL Overall)178691749.45318903.1
 
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.