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 “maderizes” 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.

83 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
maderizes214895(None) 
maderize2049071maderize_
maderized2247021maderized
laterizes18513032laterizes
modernizes2244262modernizes
adenines9310193_adenines
advertizes2344673_advertizes
aeries64737783_a_eri_es
agenizes18269743_agenizes
amberies122514683amberi_es
aperies9423203_aperi_es
apprizes2137793_apprizes
bacterizes2347983bacterizes
bakeries14312203bakeri_es
calorizes202312303calorizes
cauterizes2198003cauterizes
coderives1547483coderives
derides93420853__derides
derives114017813__derives
dimerizes2167943dimerizes
eateries8324323eateri_es
etherizes2149313etherizes
faeries104118993fa_eri_es
fakeries1559833fakeri_es
fiberizes2346183fiberizes
gauderies1147743gauderi_es
genderizes2176013genderizes
imageries1246783imageri_es
jadeites1645823jade_ites
japeries17311463japeri_es
laterites9715083laterites
laterize17613313laterize_
laterized1979933laterized
macerates132113573macerates
madeiras1144773made_iras
madeleines1343613madeleines
maderizing2346463maderizing
madrases112610003mad_rases
madres93718183mad_r__es
madrones112912283mad_rones
magnetizes227910073magnetizes
maizes175115733ma___izes
marbelizes2345373marbelizes
marines93928033ma__rines
marries93825283ma_rri_es
martyrizes2444433martyrizes
masteries111018513masteri_es
materials11510813materials
materiel10311263materi_el
materiels1147843materiels
matrices12312083ma_trices
matrixes1738063ma_trixes
mavericks2043183mavericks
maximizes2944403maximizes
memorizes221310823memorizes
mercerizes2346053mercerizes
merises93421423m__erises
mesmerizes2345993mesmerizes
miseries10320403miseri_es
misprizes2247223misprizes
moderates12710753moderates
modernes1138423moder_nes
modernises1344733modernises
modernize2144383modernize_
modernized2343733modernized
modernizer2243153modernizer
modernizers2352383modernizers
monetizes2049263monetizes
moperies12313873moperi_es
motorizes20410783motorizes
naperies10313903naperi_es
odorizes1837213_odorizes
pauperizes2344773pauperizes
racemizes2245153racemizes
rareripes1165353rareripes
ruderies9311333ruderi_es
satirizes1849393satirizes
siderites10410433siderites
soberizes2098963soberizes
suberizes20811833suberizes
tenderizes2076683tenderizes
valorizes21249083valorizes
vaporizes23228523vaporizes

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 Filter1786911486410.436409841.7
2DLD Change Limit148641836.89021573.4
3Display Results83830.0461804.3
 (SQL Overall)178691837.37224239.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.