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

272 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
porns7552734(None) 
corns76034761corns
horns86125331horns
morns75527441morns
pirns76020091pirns
pons65850601po_ns
poons75430971poons
pores75849031pores
porks115124141porks
porn65636021porn_
porno75120651porno
pornos85015251pornos
porny106020191porny
ports75934591ports
sorns55028411sorns
acorns85013012acorns
adorns74212612adorns
airns55521032airns
aprons8316992aprons
barns76335142barns
boons75031912boons
boras75938302boras
bores76448252bores
borks115727702borks
born67338412born_
borne77926792borne
borons85520542borons
borts76735452borts
bourns84114062bourns
burns74926772burns
carns75937562carns
coins75834552coins
conns75024232conns
cons66057692co_ns
coons76737282coons
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corn69945812corn_
cornu75921322cornu
cornus84816562cornus
corny106023272corny
corps95927042corps
cors66656442cor_s
curns74924272curns
darns66927892darns
dons56048702do_ns
dorks105724442dorks
dorms85723832dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
downs94918572downs
durns64819862durns
earns55927562earns
eons46638712eo_ns
erns45428222_erns
ferns85220082ferns
firns86018542firns
fohns117310782fohns
foins85523382foins
fons76943892fo_ns
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
frons86124042frons
girns64516802girns
goons65326772goons
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gowns95115102gowns
herns84825582herns
hons77350782ho_ns
horas86333092horas
horn76735612horn_
horny115619622horny
ions46737852io_ns
irons55324132irons
johns15398712johns
joins125818412joins
karns96624142karns
kerns94719562kerns
kirns95315452kirns
koans95818622koans
koras95927112koras
kors85933012kor_s
loans56026462loans
loins56728422loins
loons55731722loons
lorans65117602lorans
lords64923502lords
lores55045402lores
loris55329152loris
lorn46435252lorn_
moans74624362moans
mons68152252mo_ns
moons75331002moons
moras76438762moras
mores76249642mores
morn66237562morn_
morons84919542morons
mors65950062mor_s
morts75533562morts
mourns84111012mourns
noons54125282noons
noris54928272noris
norms76019302norms
nouns56717312nouns
ons36148512_o_ns
opens76118552opens
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ornis54616772_ornis
ors35750112_or_s
orts46538332_orts
owns76819582_owns
pains75138282pains
pans65855722p_ans
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
pawns108818132pawns
peans75437642peans
peens76428192peens
peins76128062peins
pens65649642p_ens
peons75327182peons
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
phons105221142phons
pians75126962pians
pins65558452p_ins
pions75826392pions
pirn67128372pirn_
plans75731272plans
pocks135022962pocks
pods76540152po_ds
poems95715552poems
poets76024442poets
poind84217912poind
poinds93511142poinds
point75338732point
points85618532points
pois66539042po_is
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
pond75530492po_nd
ponds85323402ponds
pone65747532po_ne
pones74547042pones
pong76231142po_ng
pongs85526342pongs
pony96434052po_ny
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poon67341262poon_
poops94422412poops
pooris83916842pooris
poos65949112po_os
popes95933812popes
pops86340952po_ps
porch125918622porch
pore66451262por_e
pored85234512pored
porgy116916122porgy
poring94227272poring
porism104518062porism
pork106929682por_k
porky145019332porky
porose84818742porose
porous84419482porous
port66059632por_t
poses74642762poses
posts75228782posts
pots66452362po_ts
poufs105616062poufs
pound84417862pound
pounds93714382pounds
pours74623182pours
pouts75530322pouts
pows95537662po_ws
poxes145325722poxes
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426402proms
prone75332622prone
prong85218112prong
prongs94314482prongs
props95726882props
pros65742782p_ros
pross76529402pross
prows106327012prows
puns66641482p_uns
purins83722652purins
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
pyins105815862pyins
pyrans11411062pyrans
pyres105523882pyres
pyros105718292pyros
roans54926442roans
scorns85713012scorns
sons46049552so_ns
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorn46641062sorn_
sorts54536662sorts
sorus54527582sorus
spoons84116012spoons
spores84726612spores
sports84619182sports
spurns84811382spurns
tarns56433952tarns
terns55226872terns
thorns95314092thorns
tons46553052to_ns
toons55027532toons
toras55540372toras
torcs75123762torcs
tores55352672tores
torn46044252torn_
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
towns86018882towns
turns55623232turns
urns46323892_urns
warns87231002warns
wons74942042wo_ns
words95425072words
works125621902works
worms105320752worms
worn75631752worn_
worts88631182worts
yarns85621792yarns
yores85031322yores
zoons144919692zoons
zoris145320012zoris

Search took 4 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.0931921408.6
2DLD Change Limit538002723.31316239.1
3Display Results2722720.1401942.9
 (SQL Overall)1786912723.54650392.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.