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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
summarizer2310427(None) 
summarize22105651summarize_
summarized24114911summarized
summarizers24132821summarizers
summarizes23125651summarizes
submariner1444072submariner
summaries13118182summari_es
summarise13115732summarise_
summarised15123912summarised
summarises14115252summarises
summerier1346422summeri_er
humanizer2345723hu_manizer
smearier1036953s_meari_er
submarine1347843submarine_
submarined1544503submarined
submariners1553223submariners
submarines1446913submarines
sugarier937393su_gari_er
summarily1643833summari_ly
summarist13116763summari_st
summarists14104703summarists
summarizing2544583summarizing
summative1646203summative_
vulgarizer23143763vulgarizer
authorizer2244544authorizer
curarize1988854cu_rarize_
curarized2176404cu_rarized
curarizes2078174cu_rarizes
dogmatizer2344114dogmatizer
formalizer24257874formalizer
glamorizer2293684glamorizer
gummier12349474gumm__i_er
humanize2247784hu_manize_
humanized2446534hu_manized
humanizers2443954hu_manizers
humanizes2347534hu_manizes
immunizer2243264_immunizer
lemmatize2245564lemmatize_
lemmatized2444284lemmatized
lemmatizes2345014lemmatizes
mariner93315994___mariner
memorizer22137644_memorizer
mesmerizer2344094mesmerizer
mummeries1247244mummeri_es
normalizer21227594normalizer
polarizer2079174_polarizer
pulverizer2443204pulverizer
rummager1343594rumma__ger
rummier11309564rumm__i_er
satirizer1846464s_atirizer
scarier94017874s__cari_er
schmalzier2692114schmalzier
scummier1445084scumm__i_er
secularizer22184994secularizer
sermonizer21146164sermonizer
slummier1235474slumm__i_er
smarmier1235034s__marmier
smarter94113134s__mar_ter
smearer94110404s_mear__er
socializer2146024socializer
solarize17511474s_olarize_
solarized1969154s_olarized
solarizes18511614s_olarizes
sommelier1343644sommeli_er
suberize19812154su_berize_
suberized2198824su_berized
suberizes20811834su_berizes
submanager1552254submanager
submarket1796084submar_ket
subscriber1643654subscriber
subsidizer2253994subsidizer
subwriter1445624su_bwriter
sudaries9312754su_dari_es
sugarer837324su_gar__er
sulfurize2144534sulfurize_
sulfurized2353514sulfurized
sulfurizes2244094sulfurizes
sultrier837774su_ltri_er
summable1436904summa_ble_
summae103911014summa___e_
summarising1653564summarising
summarizable2761374summarizable
summary14297354summar___y
summate113611664summa__te_
summated13298834summa__ted
summates122610494summa__tes
summating1437944summati_ng
summation1347804summati_on
summations1456784summations
summer104017714summ____er
summered1338144summer__ed
summeriest1476084summeriest
summering1458754summeri_ng
summerlike1873284summerlike_
summerset1347254summer_set
summertime1353024summertime_
summertimes1452864summertimes
summited13246414summ__ited
summiteer1343004summ_iteer
summitries1444644summitri_es
summoner1245534summ__oner
surmiser1036764surm__iser
surpriser1144614su_rpriser
surprize1945844su_rprize_
surprized2144664su_rprized
surprizes2045594su_rprizes
sustainer944784susta_iner
symbolizer2673384symbolizer
symmetrize2653634symmetrize_
symmetrized2853334symmetrized
symmetrizes2753754symmetrizes
sympathizer3052334sympathizer
temporizer2345234temporizer
unwarier1136884_unwari_er
vulcanizer2453434vulcanizer
vulgarize22135434vulgarize_
vulgarized24134284vulgarized
vulgarizers24172474vulgarizers
vulgarizes23145204vulgarizes
womanizer2346244_womanizer
yummier14306844yumm__i_er

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 Filter1786911614500.440406115.9
2DLD Change Limit1614501219.28017397.6
3Display Results1211210.0462630.4
 (SQL Overall)1786911219.76618297.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.