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
pasteurising155289(None) 
pasteurizing2453391pasteurizing
asterisking1652973_aste_risking
pasteurise1244123pasteuris__e
pasteurised1452603pasteuris_ed
pasteurises1343963pasteuris_es
pasturing1238433past_ur__ing
aspersing1237604_aspe_r_sing
authorising1565014_authorising
bacterizing2546114bacte_rizing
bastardising1652204bastardising
carburising1653564ca_rburising
cartelising1444794carte_lising
catechising1953544ca_techising
categorising1652574ca_tegorising
cauterizing2345954caute_rizing
laterizing2049104la_te_rizing
mastering122315314maste_r__ing
mesmerising1643934mesme_rising
moisturising1552444moist_urising
palletising1453574palle_tising
paltering122612904palte_r__ing
pasteurize2143664pasteur__ize
pasteurized2353114pasteuri_zed
pasteurizer2252654pasteuri_zer
pasteurizers2351764pasteurizers
pasteurizes2243674pasteuri_zes
pastoring12310854past_or__ing
patronising1465254pa_tronising
pattering122314434patte_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.393454684.5
2DLD Change Limit124790417.61016398.2
3Display Results41410.0301366.7
 (SQL Overall)178691418.03322244.6
 
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.