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

164 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
monished143813(None) 
minished1437871minished
monishes13311481monishes
admonished1743032admonished
banished14189072banished
finished1536482finished
ionised82911492ionis_ed
minishes13310582minishes
monied94319462moni__ed
monish114217602monish__
moshed124517492mo__shed
polished1468432polished
punished1436042punished
stonished1345592stonished
vanished15207762vanished
abolished1544273abolished
admonisher1652723admonisher
admonishes1643493admonishes
agonised10248483agonis_ed
aniseed839403_aniseed
astonished1443403astonished
banisher13169193banisher
banishes131812473banishes
burnished1544923burnished
coalshed1435013coalshed
cognised1256313cognis_ed
consisted1238513consisted
coshed124217553co__shed
cowshed1637783co_wshed
danishes121710503danishes
demolished1794523demolished
demonised1348243demonis_ed
diminished1744103diminished
dished114318713__dished
ebonised1136053ebonis_ed
enisled82510223_enisled
evanished1644333evanished
famished1766023famished
finisher1436303finisher
finishes1438983finishes
fished134316313__fished
foisted113210603fo_isted
furnished1644583furnished
garnished14196143garnished
gnashed12317523_gnashed
hoised105117433ho_is_ed
hoisted113411293ho_isted
honied104818393honi__ed
iodised9329243iodis_ed
ionise63516943ionis_e_
ionises72916433ionis_es
ionized172611293ioni_zed
joisted15379173jo_isted
jonesed1536263jones_ed
joshed174610903jo__shed
knishes1438263_knishes
lavished1555133lavished
lionised946603lionis_ed
marishes13512553marishes
mashed125325043m__ashed
mensed93916543men_s_ed
menshen1236813men_shen
menshes12310453men_shes
meshed124415933m__eshed
miched143913393m__iched
milkshed1842943milkshed
minified1439653minified
minish115216313minish__
minister10410363minister
misfed124113023m__isfed
misled94719313m__isled
missed94423603m__issed
misted93625823m__isted
modified1537273modified
modish123813543modish__
modishly1744583modishly
modiste1039283modiste_
modistes1138643modistes
moiled94318863mo_i_led
moisten93110143mo_isten
moister94015373mo_ister
molested11178243molested
monetised1246973monetis_ed
moneyed1337493mon_eyed
mongered1238953mongered
monicker1635733monicker
monie75631653moni__e_
monies83233163moni__es
moniker1338673moni_ker
monishing1547543monishing
monism104016313monis__m
monisms113512803monis_ms
monist84324983monis__t
monistic12311303monistic
monists93614783monis_ts
monitored1245583monitored
monkeyed1844153monkeyed
monkfishes2243743monkfishes
monkish1638243monkish__
monkishly2143353monkishly
monkshood1982853monkshood
monocled1337113monocled
monster93214603mon_ster
montaged12107763montaged
mooched153910533mo_oched
moonfishes1844193moonfishes
moonish123311043moonish__
moonishly1743733moonishly
moonseed1154673moonseed
mopish134311593mopish__
mopishly1864053mopishly
morphed1537133mo_rphed
mortised1178753mortis_ed
mosher114719793mo__sher
moshes115222873mo__shes
mossed94818893mo__ssed
motioned1137453motioned
motived13357763moti_ved
mouched153612593mo_uched
moused94423303mo_us_ed
moussed10338913mo_ussed
mouthed133811043mo_uthed
munched153411073mun_ched
mushed124420843m__ushed
niched125514063__niched
nighed113811293__nighed
noised75416243no_is_ed
nonsked1236243non_sked
noshed104413513__noshed
nourished1374613nourished
ozonised1853893ozonis_ed
perished14310093perished
pished124817063__pished
planished1566123planished
plenished1584953plenished
poised94918473po_is_ed
polisher1388073polisher
polishes13711783polishes
ponied94920703poni__ed
premonished1953293premonished
punisher1335773punisher
punishes1338113punishes
ravished1555713ravished
relished1239433relished
smooshed14185993smo_oshed
snowshed1534423snowshed
squished21186393squished
stonishes1247363stonishes
swished14418843_swished
tarnished13196063tarnished
tonish93415913tonish__
tonishly1445523tonishly
toolshed1244213toolshed
unfished15218293unfished
unshed10313773_un_shed
unwished15237833unwished
vanisher14167473vanisher
vanishes141610773vanishes
varnished16195613varnished
whished17428023_whished
wished134417513__wished
woodshed1644213woodshed
woolshed1553923woolshed
wooshed14167403wo_oshed

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.420425454.8
2DLD Change Limit1461621647.03320782.3
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.52923733.7
 
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.