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

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

131 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
minished143787(None) 
finished1536481finished
minishes13310581minishes
monished1438131monished
banished14189062banished
diminished1744102diminished
finisher1436302finisher
finishes1438982finishes
milkshed1842942milkshed
minified1439652minified
minish115216302minish__
minister10410362minister
monishes13311482monishes
punished1436042punished
vanished15207742vanished
admonished1743033admonished
airshed11258533ai_rshed
aniseed839403_aniseed
banisher13169183banisher
banishes131812463banishes
burnished1544923burnished
cinched153910863cin_ched
danishes121710493danishes
diminishes1644973diminishes
dished114318713__dished
enisled82510223_enisled
evanished1644323evanished
famished1766023famished
feminised15226953feminis_ed
finessed12136793finessed
finfishes1846043finfishes
finialed1255503finialed
finises10312903finis_es
finish124613413finish__
finishers1545353finishers
fished134316313__fished
furnished1644583furnished
garnished14196143garnished
gnashed12317523_gnashed
immeshed1643433immeshed
inched124514483_in_ched
incised102911583_incis_ed
inmeshed1444483_inmeshed
insisted998673_insisted
ionised82911493ionis_ed
irised73913153_iris_ed
kiboshed1842763kiboshed
knishes1438263_knishes
lavished1555133lavished
liaised837113liais_ed
linseed838203lin_seed
lionised946603lionis_ed
marishes13512553marishes
mashed125325043m__ashed
mensed93916543men_s_ed
menshen1236813men_shen
menshes12310453men_shes
meshed124415933m__eshed
miched143913393m__iched
midsized2144733midsized
milksheds1941733milksheds
mimicked1943253mimicked
minced114114913min__ced
minded103817833min__ded
mindset10313343minds_et
mined85333353min___ed
mingled113612733min_gled
minifies13312903minifies
minimised1444753minimised
minimized2345203minimized
minis75432993minis___
minishing1547073minishing
miniski1344483minis_ki
miniskis1444453miniskis
ministered1344963ministered
ministers1139623ministers
ministry1385793ministry
miniver1238393mini_ver
minored10310103min_ored
minster93914323min_ster
minted94220583min__ted
minuses93512703minus_es
minuted10329503min_uted
minxish1936213minxish__
misfed124113023m__isfed
misled94719313m__isled
missed94423603m__issed
misshod1335873mi_sshod
misted93625823m__isted
misused104111283misus_ed
mitises9315543mitis_es
monied94319463moni__ed
monish114217593monish__
moshed124517493m__oshed
munched153411073mun_ched
mushed124420843m__ushed
niched125514063__niched
nighed113811293__nighed
noshed104413503__noshed
perished14310083perished
pinched153812453pin_ched
pinfishes1746243pinfishes
pinioned1137513pinioned
pished124817063__pished
planished1566123planished
plenished1584953plenished
polished1468433polished
punisher1335773punisher
punishes1338113punishes
ravished1555713ravished
refinished1744083refinished
relished1239433relished
reminisced1544293reminisced
rinsed75016353rin_s_ed
sinister838583sinister
squished21186393squished
stonished1345593stonished
swished14418843_swished
tarnished13196063tarnished
unfinished1763113unfinished
unfished15218293unfished
unshed10313773_un_shed
unwished15237833unwished
vanisher14167453vanisher
vanishes141610753vanishes
varnished16195603varnished
vinified1537543vinified
whished17428023_whished
winched163110593win_ched
winish124212263winish__
wished134417513__wished

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621317.48619524.7
3Display Results1311310.0602183.3
 (SQL Overall)1786911317.98222386.7
 
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.