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

188 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
ponies8483346(None) 
conies84338591conies
monies83233161monies
peonies93620151peonies
phonies123717511phonies
pogies94123541pogies
pokies125921331pokies
polies84034581polies
ponces104720841ponces
pones74547041pon_es
ponied94920701ponied
pontes83627851pontes
posies84431431posies
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
epoxies1637752epoxies
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
molies84429512molies
mondes94322352mondes
monie75631652monie_
monied94319462monied
montes84226932montes
movies115118452movies
moxies154317402moxies
nonces84418832nonces
nones55639132non_es
ones46146532_on_es
opines84820702opines
pandies104224502pandies
panes76148692pan_es
panics103815362panics
panier84425502panier
paniers94717332paniers
pannes85522852pannes
pansies94521982pansies
panties94230932panties
paries84742512paries
penes75839222pen_es
penis75129322peni_s
penises9318192penises
pennies94218812pennies
peones83821042peon_es
phones114121212phon_es
phonics143110722phonics
phonied133710562phonied
phonier122710632phonier
phoniest132811532phoniest
pies66949602p__ies
pines76048862pin_es
pinier84024692pinier
piniest93121132piniest
pinites9319532pinites
pinkies133818262pinkies
pinnies93318442pinnies
pities83828082pities
pixies154915512pixies
plies74526512p_lies
podites103014732podites
poesies93217402poesies
poinds93511142poinds
pointes93216752pointes
points85618532points
pois66539042po_i_s
poise75127892po_ise
poises84226542poises
pokes116133012po_kes
pokier124914632pokier
pokiest133314912pokiest
poleis86018352poleis
poles75351002po_les
polices113118052polices
polios84019722polios
polis74731162poli_s
pomes94833932po_mes
pommies133712842pommies
ponce95222512ponce_
ponced114314812ponced
ponded105218772ponded
ponder94521692ponder
ponders103618842ponders
ponds85323402pon_ds
pone65747532pon_e_
ponged105619352ponged
pongee94920192pongee
pongees104212542pongees
pongids11347412pongids
pongs85526342pon_gs
pons65850602pon__s
pontils9312212pontils
pooves113914712pooves
popes95933812po_pes
poppies102816192poppies
popsies112816462popsies
pores75849032po_res
porgies103017002porgies
porkies133416492porkies
pornier93413132pornier
porniest103214312porniest
poses74642762po_ses
posits85718712posits
posses85128802posses
posties93128812posties
potpies113116172potpies
potsies93019482potsies
potties93723542potties
pounces114113892pounces
poxes145325722po_xes
poxier153812112poxier
poxiest163412252poxiest
pries74339532p_ries
proxies163014932proxies
punier84519222punier
puniest92918092puniest
punkies134216802punkies
punties94520782punties
pyxies18338292pyxies
sanies63031952sanies
sondes74922872sondes
sones55444142son_es
sonics84315632sonics
sonnies7315222sonnies
sponges10311042sponges
spoonies101911752spoonies
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 Limit825511882.37634743.7
3Display Results1881880.0603133.3
 (SQL Overall)1786911882.77964300.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.