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 “monocline” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

45 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
monocline134779(None) 
monoclines1446811monoclines
monoamine1347202monoamine
monocle1139662monocl__e
monoclinic1653802monoclinic
monokine1448482mono_kine
monoplane1347482monoplane
halocline1445343halocline
holocrine1495343holocrine
incline9314643_in_cline
isocline1047293_isocline
lanoline8311953lano_line
longline938763lon_gline
manacling1446283manacling
mandoline1248413mandoline
merocrine1346233merocrine
microcline1647063microcline
moline84422033m__o_line
monellin1047373monellin_
monellins1147423monellins
monoamines1446853monoamines
monocled1337113monocl_ed
monocles12310673monocl_es
monoclonal1453643monoclonal
monocoque2253313monocoque
monocycle1844443monocycle
monocyte1547893monoc_yte
monokines1547903mono_kines
monolith1349673mono_lith
monoplanes1447683monoplanes
monopolise1445883monopolise
monopolize2354703monopolize
monotint10413713mono_tint
monotone10310153mono_tone
monoxide1846293mono_xide
mooching16259063mo_oching
moonblind1442853moonblind
moonlike1476643mo_onlike
moonshine1444563moonshine
noncling11310763non_cling
nonsaline948413nonsaline
novocaine1442803novocaine
online6315843_on__line
roofline1136193ro_ofline
syncline1356073syn_cline

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 Filter1786911486410.423422437.4
2DLD Change Limit148641457.11020905.9
3Display Results45450.0162812.5
 (SQL Overall)178691457.54923670.8
 
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.