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

41 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
pasteurising155288(None) 
pasteurizing2453381pasteurizing
asterisking1652963_aste_risking
pasteurise1244103pasteuris__e
pasteurised1452603pasteuris_ed
pasteurises1343953pasteuris_es
pasturing1238433past_ur__ing
aspersing1237604_aspe_r_sing
authorising1565014_authorising
bacterizing2546104bacte_rizing
bastardising1652204bastardising
carburising1653564ca_rburising
cartelising1444794carte_lising
catechising1953544ca_techising
categorising1652574ca_tegorising
cauterizing2345944caute_rizing
laterizing2049094la_te_rizing
mastering122315304maste_r__ing
mesmerising1643934mesme_rising
moisturising1552444moist_urising
palletising1453574palle_tising
paltering122612894palte_r__ing
pasteurize2143654pasteur__ize
pasteurized2353114pasteuri_zed
pasteurizer2252654pasteuri_zer
pasteurizers2351764pasteurizers
pasteurizes2243664pasteuri_zes
pastoring12310854past_or__ing
patronising1465244pa_tronising
pattering122314424patte_r__ing
patterning1346074patte_r_ning
pauperizing2544504paupe_rizing
pestering122315664peste_r__ing
picturizing2554104pict_urizing
plastering1339244plaste_r__ing
postediting1554454poste_diting
posturing1238994post_ur__ing
pressurising1573384pressurising
pulverising1752904pulve_rising
satirising1146664sa_t_irising
westernising1653064westernising

Search took 9 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 Filter1786911247900.1561145455.1
2DLD Change Limit124790417.87315850.4
3Display Results41410.0162562.5
 (SQL Overall)178691418.04522211.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.