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

114 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
monolog1025935(None) 
monologs112210531monologs
monology142310111monology
homolog1346962homolog
menology14218482menology
monocot11412012monocot
monoglot1146842monoglot
monologic1449592monologic
monologue1245922monologue
monopod1247492monopod
analog7159973_analog
apolog938903_apolog
bonobo1037143bonobo_
bonobos1136393bonobos
colog86619933__colog
demonology1744383demonology
doxology2044743doxology
duolog835803_duolog
enology11239813_enology
homologs1448233homologs
homology1738413homology
horologe1248363horologe
horology1548123horology
iconology1545433iconology
isolog737403_isolog
magalog1144913magalog
misology1447133misology
mixology2144833mixology
modulo9256983modulo_
monaxon1644913monaxon
mondo85721233mon_do_
mondos95217333mon_dos
mongo810122413mon_go_
mongoe94214983mon_goe
mongol94912533mon_gol
mongoloid1344413mongoloid
mongols103310823mongol_s
mongos94318623mon_gos
monitor9310723monitor
mono66036723mon__o_
monocle1139663monocle
monocled1337103monocled
monocles12310673monocles
monocots1249813monocots
monodic1269783monodic
monody1238243mono_dy
monoecy1445083monoecy
monofil1247273monofil
monoglots1245373monoglots
monolith1349673monolith
monologged1543743monologged
monologies13312543monologies
monologist13413613monologist
monologued1444213monologued
monologues1346273monologues
monomer11311893monomer
monoploid1446963monoploid
monopode1347643monopode
monopods1347973monopods
monopody1645493monopody
monopole1249283monopole
monopoly1546823monopoly
monos75930863mon__os
monosome1299403monosome
monosomy1586313monosomy
monotone10310153monotone
monotony1347073monotony
monsoon938493monsoon
monthlong1542553monthlong
monuron937463monuron
mooing93718373mo_oing
mool67533863mo_ol__
moola75117033mo_ol_a
moolah11409193mo_olah
moolas83615593mo_olas
mooley11311633mo_oley
mools76027173mo_ol_s
moonbow1443873moonbow
mooning103415553mooning
moonlet92413273moonlet
moonlit9229333moonlit
mouflon12104083mouflon
mycology1946153mycology
myology1636163m_yology
nolo46229313__nolo_
nolos54423353__nolos
nomology1446843nomology
noncolor1046513noncolor
nosology1246143nosology
oenology12227823oenology
oinology12196703oinology
oncology14216973_oncology
ontology12267583_ontology
oology103210253_o_ology
oolong738073_o_olong
orology11319463_orology
otology11308753_otology
ovolo8339173_ovolo_
ovolos9257203_ovolos
penology14238483penology
phonology1847163phonology
poenology1546343poenology
pomology1637193pomology
posology1447243posology
prolog94212973_prolog
sinology12247183sinology
sonovox1743013sonovox
theolog1146153theolog
tocology14107383tocology
tokology1655703tokology
topology1467213topology
unclog956603_unclog
venology15226633venology
zoology2036513zo_ology

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271147.29618369.9
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.49823831.8
 
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.