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

132 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
porny10602019(None) 
corny106023271corny
horny115619621horny
pony96434051po_ny
porgy116916121porgy
porky145019331porky
porn65636021porn_
porno75120651porno
porns75527341porns
barny105821732barny
bonny105816622bonny
bony96732082bo_ny
born67338412born_
borne77926792borne
borty105522832borty
carny105822922carny
cony96537832co_ny
corby125018532corby
corky145221152corky
corn69945812corn_
corns76034762corns
cornu75921322cornu
cory96941512cor_y
crony105918672crony
dorky135518742dorky
dormy115817472dormy
dorty96220812dorty
dory85836232dor_y
downy125714552downy
ferny115816182ferny
foray115023972foray
forby135317672forby
forky156119642forky
forty114824272forty
goony95519782goony
gorsy95915782gorsy
gory86129662gor_y
horn76735612horn_
horns86125332horns
horsy116318392horsy
irony85015902irony
koruny1334442koruny
loony86918962loony
lorn46435252lorn_
lorry86315672lorry
lory75931712lor_y
mony96830012mo_ny
moony104818272moony
moray105423792moray
morn66237562morn_
morns75527442morns
orby97519602_orby
orgy85218002_orgy
pardy115523952pardy
parry105323752parry
party106630612party
penny105119452penny
peony105717562peony
perdy115417332perdy
perky145319482perky
perry105222712perry
phony136715442phony
pinny105222062pinny
piny911838352p_iny
pirn67128372pirn_
pirns76020092pirns
poboy121612222poboy
pocky165314602pocky
podgy125610772podgy
poesy105014062poesy
pogey116017892pogey
pogy105623552po_gy
poind84217912poind
point75338732point
pointy114913282pointy
pokey145318972pokey
poky135922152po_ky
poly96235152po_ly
pommy14449862pommy
pond75530492po_nd
pone65747532po_ne
pong76231142po_ng
pons65850602po_ns
poofy136213272poofy
poon67341262poon_
poons75430972poons
poorly1137892poorly
poppy114813192poppy
popsy125713402popsy
porch125918622porch
pore66451262por_e
pored85234512pored
pores75849032pores
poring94227272poring
pork106929682por_k
porks115124142porks
pornos85015252pornos
port66059632por_t
portly114713402portly
ports75934592ports
posy96028422po_sy
potsy105815612potsy
potty105621002potty
pound84417862pound
pouty107018812pouty
poxy166820892po_xy
pray96331532p_ray
prey96228482p_rey
prone75332622prone
prong85218112prong
prosy106319252prosy
proxy175011012proxy
pry85728052p_r_y
punny104217712punny
puny95526992p_uny
pursy105016412pursy
purty105019402purty
sonny85016102sonny
sorn46641062sorn_
sorns55028422sorns
sorry84618252sorry
spoony114111792spoony
sporty115112492sporty
thorny12509842thorny
tony75635152to_ny
torn46044252torn_
tory75840542tor_y
towny116114492towny
wordy126916162wordy
wormy137514252wormy
worn75631752worn_
worry116114332worry

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001321.54634799.5
3Display Results1321320.0304400.0
 (SQL Overall)1786911321.88994595.6
 
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.