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

155 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
monocle113966(None) 
monocled1337111monocled
monocles12310671monocles
binocle1136492binocle
manacle11310282manacle
monocline1347792monocline
monocot11412012monocot
monocycle1844442monocycle
monocyte1547892monocyte
monopole1249282monopole
pinocle1138142pinocle
anole55330383_ano_le
binocles1236413binocles
boodle93215033bo_odle
boucle103712783bo_ucle
cenacle1139123cenacle
condole102914953condole
condyle13247053condyle
console92715983console
coracle112011723coracle
cornicle1258783cornicle
dongle83612493don_gle
doodle83212853do_odle
ennoble935633ennoble
fondle104412943fon_dle
footle93914383fo_otle
foozle18369203fo_ozle
funicle12237483funicle
gonocyte1454873gonocyte
hondle103914523hon_dle
honoree10412113honoree
ignoble1043613ignoble
ionone6313443iono_ne
macle96127003m__acle
manacled1336453manacled
manacles1239523manacles
manche133515103man_che
mangle93921333man_gle
manhole12311343manhole
manille92613273manille
maniple11249653maniple
mantle84420923man_tle
menace103216943menac_e
minable112315073minable
mince95325233min_c_e
mingle93518783min_gle
miracle1138843miracle
mobile103613543mo_bile
module93011033mo_dule
mole66251833m__o_le
molecule1294693molecule
moloch1356483moloc_h
molochs1435223molochs
monacid121310243monacid
monde85723143mon__de
mongoe94214983mon_goe
mongol94912533mongol_
mongols103310823mongols
mongoose1175353mongoose
mongrel1036333mongrel
monicker1635733monicker
monie75631653mon__ie
mono66036723mono___
monoacid13137223monoacid
monocarp14136113monocarp
monoclines1446813monoclines
monocoque2253313monocoque
monocots1249813monocots
monocrat12410783monocrat
monocular1345813monocular
monocycles1944613monocycles
monocytes1647973monocytes
monodic1269783monodic
monodies11312503monodies
monody1238243mono_dy
monoecies1348863monoecies
monoecy1445083monoecy
monofil1247273monofil
monofils1346963monofils
monofuel1344053monofuel
monoglot1146843monoglot
monohull1343953monohull
monokine1448483monokine
monolog10259353monolog
monomer11311893monomer
monoplane1347483monoplane
monopod1247493monopod
monopode1347643monopode
monopoles1349573monopoles
monopoly1546823monopoly
monos75930863mono__s
monosome1299403monosome
monostele1145333monostele
monotone10310153monotone
monotype1545783monotype
monoxide1846293monoxide
montage101211713montage
montane91313623montane
monte75829773mon__te
monthly1535673monthly
monticule1344713monticule
mooch125313613mo_oc_h
mooched153910533mo_oched
moocher143610673mo_ocher
mooches143714453mo_oches
mool67533863mo_o_l_
moola75117033mo_o_la
mooley11311633mo_o_ley
mools76027173mo_o_ls
mooncalf1544533mooncalf
mooneye12116933mooneye
moonily1248943moonily
moonlet92413273mo_onlet
moose76327193mo_o_se
mopoke1436633mopo_ke
morale85220553mo_rale
morelle91210803morelle
morocco1343523morocco
morose85116243moro_se
motile83818343mo_tile
mottle84116053mo_ttle
mouille937843mouille
movable14189433movable
muscle10310973m_uscle
noble74420993__noble
nonce75719823non_c_e
noncola948303noncola
noncore9411953noncore
nonnoble1055343nonnoble
nonoily1049543nonoily
nonuple946153nonuple
noodle73212543no_odle
nuncle839363nun_cle
obole75917143_obo_le
once65423083_on_c_e
oracle84313293_oracle
panicle11129983panicle
panoche1456383panoche
penoche1447043penoche
pinochle1544753pinochle
pinocles1248693pinocles
pinole83218783pino_le
ponce95222513pon_c_e
poodle93112043po_odle
posole8314223poso_le
pozole1758913pozo_le
rootle63214453ro_otle
sanicle91210263sanicle
snoozle16305913snoozle
socle7419573__socle
soroche1237183soroche
tootle62613813to_otle
tunicle9308033tunicle
uncle7317053_un_cle
zonule1577483zon_ule

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340271556.03322215.6
3Display Results1551550.0463369.6
 (SQL Overall)1786911556.49927495.2
 
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.