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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

173 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
monies8323316(None) 
conies84338591conies
molies84429511molies
mondes94322351mondes
monie75631651monie_
monied94319461monied
montes84226931montes
movies115118451movies
moxies154317401moxies
ponies84833461ponies
agonies83016622agonies
atonies75320952atonies
bodies94524142bodies
bogies94724312bogies
bones76446532bon_es
bonier84321992bonier
boniest93318992boniest
bonnes85621452bonnes
bonzes175116102bonzes
boonies93422482boonies
colies84837052colies
cones76457422con_es
conges94928172conges
conics103920592conics
conines93827792conines
conins84327232conins
contes84432912contes
copies104130302copies
cosies84932152cosies
cozies174521412cozies
cronies9622502cronies
denies74729642denies
dobies94422092dobies
dogies85022252dogies
donees74519492donees
dories75232362dories
doxies143917852doxies
ebonies9312882ebonies
fogies104118062fogies
genies75324942genies
gobies95418062gobies
gonifs104310132gonifs
goonies83618332goonies
holies94630032holies
homies114524722homies
hones88144492hon_es
hongies112716472hongies
honied104818392honied
honkies143015142honkies
ionics84214482ionics
ionise63516942ionise
ionises72916432ionises
ionizes162813342ionizes
ironies7517422ironies
jones125028182jon_es
koines10415732koines
longes75925572longes
longies82916552longies
looies65025832looies
loonies73919542loonies
lories64933042lories
louies64525102louies
lunies64723012lunies
mamies104626242mamies
manes76648962man_es
manges94628942manges
manias84029032manias
manics103919932manics
manses84225512manses
mantes84430782mantes
mavies114923192mavies
meanies93620742meanies
meinies92516072meinies
menses84222452menses
minces104420802minces
mines75651952min_es
minims104514812minims
minis75432992mini_s
minkes124618782minkes
minnies93617362minnies
minxes154612982minxes
mobiles112813122mobiles
modes85537412mo_des
moggies113111722moggies
moils76125752mo_ils
moires8915632moires
mojoes15399522mojoes
mokes114631032mo_kes
moles74747922mo_les
mollies93420232mollies
momes95134472mo_mes
mommies103912272mommies
monades103713822monades
monads94515302monads
monas74732152mon_as
monde85723142monde_
mondos95217332mondos
money104826842mon_ey
moneys115513622moneys
monger94418332monger
mongers104217272mongers
mongoes103415712mongoes
mongos94318622mongos
moniker1338672moniker
monikers1437412monikers
monish114217592monish
monishes13311482monishes
monism104016312monism
monisms113512802monisms
monist84324982monist
monists93614782monists
monkey153710592monkey
monkeys16407422monkeys
monks116123392mon_ks
monodies11312502monodies
monos75930862mon_os
mons68152262mon__s
monte75829772monte_
months113812932months
moonier93714102moonier
mooniest103014172mooniest
mopes95134982mo_pes
mopier103914782mopier
mopiest113014292mopiest
mores76249642mo_res
moshes115222872moshes
mosses85527682mosses
motes75944002mo_tes
motifs1139672motifs
motiles93317432motiles
motives123611892motives
mottes85523692mottes
moues75732842mo_ues
mouses85531422mouses
moves106128422mo_ves
movie105319132movie_
moxie144018122moxie_
munis75022002muni_s
myopies14309722myopies
nonces84418832nonces
nones55639132non_es
ones46146532_on_es
peonies93620152peonies
phonies123717512phonies
pogies94123542pogies
pokies125921332pokies
polies84034582polies
ponces104720842ponces
pones74547042pon_es
ponied94920702ponied
pontes83627852pontes
posies84431432posies
sanies63031952sanies
simonies10311112simonies
sondes74922872sondes
sones55444142son_es
sonics84315632sonics
sonnies7315222sonnies
tobies84521022tobies
todies74223552todies
tones56048662ton_es
tonics83617862tonics
tonier65520712tonier
toniest73218902toniest
tonnes65320852tonnes
toonies73719882toonies
tories65435882tories
towies93521192towies
townies103113622townies
yonis85020822yoni_s
yowies123913732yowies
zanies153219672zanies
zones145528042zon_es

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511732.25036689.3
3Display Results1731730.0503460.0
 (SQL Overall)1786911732.64367609.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.