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 “westernisation” with Change Limit: [1] [2] [3] [4] [5] [6]

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
westernisation1715256(None) 
westernisations18172421westernisations
westernization26134461westernization
westernizations27154112westernizations
eternization2158663_e_ternization
determination1657644de_termination
esterification1995324_esterification
eternizations2258064_e_ternizations
extermination2275744_extermination
externalisation2272764_externalisation
fraternization26174054fraternization
modernisation1652764_modernisation
sternutation1253964__sternutation
weatherization2954144weather_ization
westernising1653064westernis__ing
winterization25137804winter_ization
aestivation1447925aest___ivation
alternation1147625_altern__ation
bacterization26107205bacter_ization
bastardization26143075bastardization
cauterization24187745cauter_ization
consternation15106355constern__ation
desalinization2455615desalinization
desperation14510115desper___ation
destination12413845dest___ination
deterioration14145285de_terioration
determinations1766895de_terminations
deuteration1249105deuter___ation
dispensation1555595dispe_n_sation
energization2256495_e_nergization
esterifications20134805_esterifications
estimation12410845_est___imation
estivation1349815_est___ivation
etherization2457685_ether_ization
exercitation2155385_e_xercitation
extenuation1845185_exte_n_uation
exterminations2365125_exterminations
externalization3164515_externalization
extrication2049795_ext_r_ication
fraternizations27153745fraternizations
generalisation1553725ge_neralisation
hellenization2554195helle_nization
herniation1348445___herni_ation
interanimation16135995_interanimation
laterization21410675_later_ization
luteinization2255295_luteinization
mercerization2656325mercer_ization
metrication15410655me_t_r_ication
modernisations1752725_modernisations
modernization2555335_modernization
ostentation1146935_oste_n_tation
pasteurization2584415pasteurization
pretermination1854775pretermination
redetermination18102295redetermination
reiteration11412165reiter___ation
reservation1489145res_er__vation
restoration11412095restor___ation
restriction1349365rest_r_i_ction
sensation9510585__s_e_n_sation
seriation9318065__s_er_i_ation
sterilization2258845__sterilization
sternutations1353755__sternutations
striation9313485__st_r_i_ation
sustentation1255005suste_n_tation
systemization2774435syste_mization
tenderization2355735tender_ization
termination131311165___termination
tetanization21410285te_t_anization
weatherizations3054075weather_izations
westernise1344275westernis____e
westernised1552915westernis___ed
westernises1444205westernis___es
westernizing2553725westerni__zing
winterizations26157495winter_izations

Search took 8 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 Filter178691950240.1261418182.5
2DLD Change Limit95024747.35612917.9
3Display Results74740.0631174.6
 (SQL Overall)178691747.54523683.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.