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

163 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
monocles1231067(None) 
monocle1139661monocle_
monocled1337111monocled
binocles1236412binocles
manacles1239522manacles
monoclines1446812monoclines
monocots1249812monocots
monocycles1944612monocycles
monocytes1647972monocytes
monodies11312502monodies
monoecies1348862monoecies
monopoles1349572monopoles
mooches143714452mo_oches
pinocles1248692pinocles
anoles64827433_ano_les
binocle1136493binocle_
boodles103416043bo_odles
boucles113113003bo_ucles
cenacles1238023cenacles
conches144019813con_ches
condoles113015803condoles
condyles14277463condyles
consoles103216153consoles
cooches143515833co_oches
coracles121811163coracles
cornicles1368243cornicles
dongles93212873don_gles
doodles93614163do_odles
ennobles1045113ennobles
fondles113512613fon_dles
footles103715713fo_otles
foozles19329543fo_ozles
funicles13246833funicles
gonocytes1544733gonocytes
hondles113614523hon_dles
honorees1148773honorees
hooches153812523ho_oches
ionones7313883iono_nes
macles107023223m__acles
manacle11310283manacle_
manacled1336453manacled
manches143818623man_ches
mangles104021463man_gles
manholes13311183manholes
manilles102312603manilles
maniples12269423maniples
mantles94820703man_tles
menaces112715523menac_es
mensches1536303mensches
minces104420803min_c_es
mingles103719003min_gles
miracles1238333miracles
mobiles112813123mo_biles
modules102511003mo_dules
mojoes15399523mojo__es
molecules1364613molecules
moles74747923m__o_les
molochs1435223moloc_hs
monacids13137513monacids
monades103713823mon_ades
mondes94322353mon__des
moneyless1444653moneyless
mongoes103415713mon_goes
mongols103310823mongol_s
mongooses1285603mongooses
mongrels1135333mongrels
monicker1635733monicker
monickers1745083monickers
monies83233163mon__ies
monishes13311483monishes
monoacids14145793monoacids
monocarp14136113monocarp
monocarps1595643monocarps
monocline1347793monocline
monocoques2353433monocoques
monocot11412013monoc_ot
monocrat12410783monocrat
monocrats1348533monocrats
monocular1345813monocular
monoculars1444503monoculars
monocycle1844443monocycle_
monocyte1547893monocyte
monofils1346963monofils
monofuel1344053monofuel
monofuels1443243monofuels
monoglot1146843monoglot
monoglots1245373monoglots
monohulls1443863monohulls
monoicous1345973monoicous
monokines1547903monokines
monolog10259353mono_log
monologs112210533monologs
monomer11311893mono_mer
monomers12311033monomers
monoplanes1447683monoplanes
monopodes1447723monopodes
monopods1347973monopods
monopole1249283monopole_
monopolies1448043monopolies
monos75930863mono___s
monosomes1399403monosomes
monosteles1245573monosteles
monotones11410553monotones
monotypes1646163monotypes
monoxides1946133monoxides
montages111412183montages
montanes101114523montanes
montes84226933mon__tes
monthlies1446513monthlies
monticules1444793monticules
mooched153910533mo_oched
moocher143610673mo_ocher
moochers15369123mo_ochers
moolas83615593mo_o_las
mooley11311633mo_o_ley
mooleys1236863mo_o_leys
mools76027173mo_o_l_s
mooncalves1752013mooncalves
mooneyes1396113mooneyes
moonless10278043mo_onless
moonlet92413273mo_onlet
moonlets10247473mo_onlets
mopokes1536693mopo_kes
morales93619403mo_rales
morelles10710493morelles
moroccos1443813moroccos
motiles93317433mo_tiles
motorless1145723motorless
mottles93415803mo_ttles
mouches143815963mo_uches
movables15175573movables
munches144215793mun_ches
muscles11310563m_uscles
nobles83319723__nobles
nonces84418833non_c_es
noncolas1048613noncolas
nonuples1056533nonuples
noodles83513193no_odles
nuncles939843nun_cles
oboles83815833_obo_les
oodles73517183_o_odles
oracles93212423_oracles
panicles121010113panicles
panoches1548123panoches
penoches1538933penoches
pinochles1644863pinochles
pinocle1138143pinocle_
pinoles93418703pino_les
ponces104720843pon_c_es
pooches143214163po_oches
poodles103013513po_odles
posoles9314883poso_les
pozoles1839063pozo_les
rootles73215633ro_otles
sanicles10149943sanicles
smooches15217263smo_oches
snoozles17335563snoozles
socles8418453__socles
soroches1338803soroches
tootles72915603to_otles
tunicles10217133tunicles
uncles8317163_un_cles
zonules1647793zon_ules

Search took 9 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.423422437.4
2DLD Change Limit1461621637.59319249.6
3Display Results1631630.0802037.5
 (SQL Overall)1786911638.09622071.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.