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

64 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
monetary134652(None) 
cometary1547692cometary
momentary1645232momentary
monetarily1554082monetarily
monitory1347852monitory
mortary12369042mo_rtary
boneyard1475323boneyard
cinerary1346433cinerary
contrary1347493contrary
dietary1158663_dietary
funerary1443643funerary
honorary1445803honorary
mandatary1543243mandatary
manuary1237773man_uary
military1347233military
minatory1338553minatory
moiety1148223moiet__y
monandry1443233monandry
monastery1444373monastery
moneran9311113monera_n
monerans10310343monerans
monetarism1445993monetarism
monetarist1258333monetarist
monetise10311473monetise
monetize1949983monetize
money104826843mone___y
moneyer1237903moneyer_
moneyers1337423moneyers
monitor9310723monitor_
monitors10310823monitors
monkery16317453mon_kery
monocarp14136113monocarp
monogamy1645113monogamy
monotony1347073monotony
monster93214603monster_
monstera10318883monstera
monsters103314553monsters
montage101211713mon_tage
montane91313623mon_tane
montero9310133mon_tero
monthly1535673mon_thly
mopery135210973mope__ry
moratory1347823moratory
mortar83812043mo_rtar_
mortars93411523mo_rtars
mortuary1373923mortuary
nectary1246223__nectary
nonentry1146813nonentry
nonmonetary1652983nonmonetary
nonstory1148103nonstory
notary92310713__notary
onery8414123_one__ry
planetary1443903planetary
poetry1139383po_et_ry
proletary1445843proletary
rosemary1344433rosemary
rotary92411303ro__tary
sanitary1146753sanitary
solitary1146503solitary
tonearm937443tone_arm
unitary1038613_unitary
vinegary1543893vinegary
votary12248333vo__tary
zonary1838793zon__ary

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.453394461.4
2DLD Change Limit146162647.73618893.7
3Display Results64640.0302133.3
 (SQL Overall)178691648.21921741.2
 
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.