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

104 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
monocled133711(None) 
monocle1139661monocle_
monocles12310671monocles
manacled1336452manacled
mooched153910532mo_oched
binocle1136493binocle_
binocles1236413binocles
boodled113410933bo_odled
concocted1346763concocted
condoled123110723condoled
consoled112911453consoled
cooled95224593co_o_led
doodled10369463do_odled
ennobled1143833ennobled
fondled12399423fon_dled
fooled104317823fo_o_led
footled113610763fo_otled
foozled20346893fo_ozled
hondled123510653hon_dled
honored11310123hono_red
honoured1236313honoured
knocked13236303_knocked
knolled12296573_knolled
macled116718113m__acled
manacle11310283manacle_
manacles1239523manacles
mangled113615263man_gled
mantled104113393man_tled
menaced122710093menac_ed
minced114114913min_c_ed
mingled113612733min_gled
minored10310103mino_red
mobled113213183m__obled
mocked154716613m__ocked
modeled1139463mo_deled
modelled1236433modelled
moguled1135933mo_guled
moiled94318863m__oiled
monacid121310243monac_id
moneyed1337493mon_eyed
mongered1238953mongered
monicker1635733monicker
monied94319463mon__ied
monished1438133monished
monkeyed1844153monkeyed
monoacid13137223monoacid
monocarp14136113monocarp
monochord1745343monochord
monocline1347793monocline
monoclines1446813monoclines
monocot11412013monoc_ot
monocots1249813monocots
monocrat12410773monocrat
monocular1345813monocular
monocycle1844443monocycle_
monocycles1944613monocycles
monocyte1547893monocyte
monocytes1647973monocytes
monodies11312503monodies
monoecies1348863monoecies
monofuel1344053monofuel
monoglot1146843monoglot
monolog10259353mono_log
monomer11311893mono_mer
monoploid1446963monoploid
monopod1247493mono_pod
monopode1347643monopode
monopole1249283monopole_
monopoles1349573monopoles
monorchid1746163monorchid
monoxide1846293monoxide
montaged12107763montaged
moocher143610673mo_ocher
mooches143714453mo_oches
mooed85123983mo_o__ed
mooley11311633mo_o_ley
mooned94216643mo_o_ned
moonlet92413273mo_onlet
moonseed1154673moonseed
moored93814173mo_o_red
mooted94120373mo_o_ted
morseled1147193morseled
motored1039933moto_red
mottled10409973mo_ttled
mouched153612593mo_uched
munched153411073mun_ched
muscled1237783m_uscled
nocked134617383__nocked
noodled9339923no_odled
panicled13106783panicled
pinocle1138143pinocle_
pinocles1248693pinocles
ponced114314813pon_c_ed
pooched152810083po_oched
pooled94619813po_o_led
rootled83410533ro_otled
smooched16185983smo_oched
snooled84513943_snooled
snoozled18344493snoozled
tooled74918903to_o_led
tootled83511043to_otled
unoiled82415483_unoiled
wooled103715503wo_o_led
woolled1136643wo_olled

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 Limit1461621046.72021750.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.18624866.5
 
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.