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

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

85 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
memorizes22131082(None) 
memories121214351memori_es
memorises131211581memorises
memorize211311101memorize_
memorized23138991memorized
memorizer22137641memorizer
memorizers23125001memorizers
demonizes21311062demonizes
emprizes2138132_emprizes
melodizes2146752melodizes
memorials1346562memorials
memorise121411432memorise_
memorised14118232memorised
memoriter13126572memoriter
mesmerizes2345992mesmerizes
motorizes20410782motorizes
temporizes2346932temporizes
amortizes2087283_amortizes
aphorizes2348013aphorizes
arborizes2088823arborizes
armories10313653armori_es
calorizes202312303calorizes
colorizes203014523colorizes
comprizes2468943comprizes
deionizes1958213deionizes
demonises12311093demonises
demonize20311533demonize_
demonized2239853demonized
demoralizes2368433demoralizes
deodorizes2145363deodorizes
dimerizes2167943dimerizes
ebonizes1938073_ebonizes
emeries91620023_emeri_es
emprises12311003_emprises
emprize2038843_emprize_
erotizes17311213_erotizes
exorcizes2744253_exorcizes
feminizes23238523feminizes
glamorizes2295453glamorizes
hemolyzes2664623hemolyzes
heroizes202610983hero_izes
maderizes2148953maderizes
melanizes20410383melanizes
melodies11310123melodi_es
melodises1247603melodises
melodize2046663melodize_
melodized2245453melodized
melodizer2144413melodizer
melodizers2243383melodizers
membranes1545573membranes
memoirists1444133memoirists
memoirs1136803memo_i_rs
memorial1249523memori_al
memorializes2556003memorializes
memorizing2448113memorizing
mercerizes2346053mercerizes
merises93421423me__rises
mesmerises1445823mesmerises
mesmerize2246033mesmerize_
mesmerized2444863mesmerized
mesmerizer2344093mesmerizer
mesmerizers2452653mesmerizers
metalizes20414243metalizes
meteorites1247613meteorites
methodizes2545583methodizes
misprizes2247223misprizes
motorises11311673motorises
motorize19410433motorize_
motorized2148663motorized
odorizes1837213_odorizes
pemolines1348623pemolines
remorses10311993remor_ses
sermonizes21148363sermonizes
simonizes2047823simonizes
temporises1447243temporises
temporize2246873temporize_
temporized2446063temporized
temporizer2345233temporizer
temporizers2443733temporizers
tenorites9311103tenorites
terrorizes1987063terrorizes
theorizes2147073theorizes
valorizes21249083valorizes
vaporizes23228523vaporizes
velarizes2148653velarizes

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 Filter1786911486410.436409841.7
2DLD Change Limit148641857.64319448.0
3Display Results85850.0302833.3
 (SQL Overall)178691858.10922036.1
 
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.