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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 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
westernisations18172431westernisations_
westernisation17152572westernisation__
westernizations27154132westernizations_
westernization26134483westernization__
eternizations2258074_e_ternizations_
determinations1766895de_terminations_
esterifications20134815_esterifications_
eternization2158675_e_ternization__
exterminations2365125_exterminations_
fraternizations27153755fraternizations_
modernisations1752725_modernisations_
sternutations1353755__sternutations_
weatherizations3054075weather_izations_
westernising1653065westernis__i_n_g
winterizations26157505winter_izations_
aestivations1547486aest___ivations_
alternations1246776_altern__ations_
bacterizations2766666bacter_izations_
bastardizations27112876bastardizations_
cauterizations25197156cauter_izations_
consternations16116046constern__ations_
desalinizations2555396desalinizations_
desperations1559526desper___ations_
destinations13412666dest___inations_
deteriorations15164696de_teriorations_
determination1657646de_termination__
deuterations1348086deuter___ations_
dispensations1655486dispe_n_sations_
energizations2356186_e_nergizations_
esterification1995336_esterification__
estimations1349946_est___imations_
estivations1449276_est___ivations_
etherizations2557236_ether_izations_
exercitations2254566_e_xercitations_
extenuations1945086_exte_n_uations_
extermination2275746_extermination__
externalisation2272766_externalisation__
extrications2149056_ext_r_ications_
fraternization26174066fraternization__
generalisations1673626ge_neralisations_
hellenizations2654326helle_nizations_
herniations1447406___herni_ations_
interanimations17115196_interanimations_
laterizations22410076_later_izations_
luteinizations2355066_luteinizations_
mercerizations2756106mercer_izations_
metrications1649836me_t_r_ications_
modernisation1652766_modernisation__
modernizations2654936_modernizations_
ostentations1246126_oste_n_tations_
pasteurizations2674006pasteurizations_
preterminations1954306preterminations_
reiterations12410876reiter___ations_
reservations1588586res_er__vations_
restorations12410956restor___ations_
restrictions1449286rest_r_i_ctions_
sensations1059856__s_e_n_sations_
seriations10316686__s_er_i_ations_
sterilizations2357986__sterilizations_
sternutation1253966__sternutation__
striations10312796__st_r_i_ations_
sustentations1354786suste_n_tations_
systemizations2864086syste_mizations_
tenderizations2455696tender_izations_
terminations14149766___terminations_
tetanizations2249916te_t_anizations_
weatherization2954146weather_ization__
westernises1444206westernis____es_
westernizing2553726westerni__zi_n_g
winterization25137816winter_ization__

Search took 5 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 Filter178691658740.1101624463.6
2DLD Change Limit65874704.70314006.8
3Display Results70700.0461521.7
 (SQL Overall)178691704.85936775.3
 
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.