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

325 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
sorn4664106(None) 
born67338411born
corn69945811corn
horn76735611horn
lorn46435251lorn
morn66237561morn
porn65636021porn
scorn75817441scorn
shorn85722171shorn
son37761951so_n
soon46240501soon
sora45746911sora
sorb68333041sorb
sord56237201sord
sore47059531sore
sori46039831sori
sorns55028411sorns
sort46264811sort
sown75127451sown
sworn86115301sworn
torn46044251torn
worn75631751worn
acorn75616622acorn
adorn64917092adorn
airn46433832airn
barn66444642barn
boon67142172boon
bora66141632bora
bore66051332bore
bork106933822bork
borne77926792borne
boron76727142boron
bort65960962bort
bourn75518482bourn
burn65636422burn
carn66245432carn
coin66645352coin
con510268022co_n
conn66229132conn
coon67248942coon
cor59960942cor_
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corns76034762corns
cornu75921322cornu
corny106023272corny
cors66656442cors
cory96941512cory
curn66731882curn
darn56434622darn
don46757652do_n
dor47253922dor_
dore56353302dore
dork96531462dork
dorm76834622dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
down86427492down
durn56127622durn
earn46737552earn
eon36052082eo_n
ern35738352_ern
fern76129322fern
firn76927502firn
fohn106116552fohn
foin77231562foin
fon66352272fo_n
for66952072for_
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
girn56026862girn
goon57236172goon
gor47848262gor_
gore55744962gore
gorm75529392gorm
gorp75625902gorp
gory86129662gory
gown85724072gown
hern76134892hern
hon67759382ho_n
hora76136552hora
horns86125332horns
horny115619622horny
ion36051022io_n
iron46728462iron
john145512902john
join116724832join
karn86129412karn
kern85326212kern
kirn87123432kirn
koan85425032koan
kor76538892kor_
kora86431552kora
kore85834162kore
kors85933012kors
korun9411922korun
loan47436452loan
loin46838722loin
loon47344792loon
loran55925092loran
lord55032082lord
lore45850352lore
lory75931712lory
lown76929292lown
moan65832012moan
mon57561572mo_n
moon67140812moon
mor56855002mor_
mora66641272mora
more67154522more
morns75527442morns
moron76925422moron
mors65950062mors
mort66758832mort
mourn77215012mourn
mown95424442mown
noon47134622noon
nor38048822nor_
nori47133142nori
norm66429812norm
noun45724182noun
on28057182_o_n
or27354732_or_
ora37250832_ora
orb55736862_orb
orc57034922_orc
ore36661832_ore
ors35750112_ors
ort39465232_ort
own66429702_own
pirn67128372pirn
poon67341262poon
pore66451262pore
pork106929682pork
porno75120652porno
porns75527342porns
porny106020192porny
port66059632port
roan47234202roan
sain45551292sain
saran53730302saran
sard55344242sard
sari45444042sari
sarin55239252sarin
sark84938972sark
sawn75428162sawn
scan65530452scan
score75526732score
scorns85713012scorns
scry96017762scry
seen46943122seen
sen36058522s_en
ser36752402ser_
sera46141392sera
sere46153472sere
serf76340112serf
serin55434442serin
sers45746652sers
sewn76124332sewn
sharn84823702sharn
shin75634302shin
shoon84022002shoon
shoran94016032shoran
shore85432642shore
shorl84720242shorl
short85040522short
shown115216472shown
shri76021692shri
shun75122772shun
sign55523052sign
sin36265892s_in
sir35746672sir_
sire46150412sire
siren54525822siren
sirs44338332sirs
skin85927522skin
skort94925632skort
snore55424952snore
snort54833752snort
so28855442so__
soak87227662soak
soap65831132soap
soar46838672soar
soars54732512soars
sob57857942so_b
soba64927922soba
sobs64941752sobs
soca66330052soca
sock105233212sock
sod46053702so_d
soda56329382soda
sods54940212sods
sofa75625602sofa
soft76942822soft
soil46138822soil
soja115619512soja
soke85436262soke
sol37256622so_l
sola45541862sola
solan55328152solan
sold54837412sold
sole46053672sole
soli46637002soli
solo45538942solo
solon55026132solon
sols45448162sols
som59153802so_m
soma65635292soma
soman75024902soman
some66040382some
soms66239372soms
sone46649982sone
song55133672song
sonny85016102sonny
sons46049552sons
sook84933392sook
soot45761052soot
sop57557862so_p
soph97024202soph
sops65244562sops
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sored66141782sored
sorel56231442sorel
sorer56236572sorer
sores55454282sores
sorgo64719722sorgo
soring74731882soring
sorned74820042sorned
sorner64720382sorner
sorry84618252sorry
sorta57125412sorta
sorts54536662sorts
sorus54527582sorus
sos37761602so_s
sot310384292so_t
soth75932512soth
sots45552442sots
sou37853692so_u
souk86127172souk
soul46435712soul
sound64420022sound
soup66232912soup
sour45935892sour
sours55230502sours
sous46947212sous
sovran937152sovran
sow66554762so_w
sows75342492sows
sox106444192so_x
soy67851452so_y
soya75724432soya
soys75233932soys
sozin14514522sozin
span65234662span
spin66231302spin
spoon74719442spoon
spore75428592spore
sport75935982sport
spry96819122spry
spun66221462spun
spurn74815452spurn
sri35634002s_ri
stern55319122stern
store56333812store
stork96819692stork
storm76520372storm
story86723032story
stun45623452stun
suborn8310002suborn
sun37149032s_un
sunn45423592sunn
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
swan76631312swan
swoon85014782swoon
sword95214112sword
swore84920812swore
swoun84811492swoun
syn67024122s_yn
syren85216742syren
tarn46842722tarn
tern46134802tern
thorn85318702thorn
ton310265102to_n
toon47740632toon
tor39261682tor_
tora47545992tora
torc66333352torc
tore47359322tore
tori47542152tori
toro48045682toro
torr45630902torr
tors46157382tors
tort46967462tort
tory75840542tory
town76928702town
turn46330382turn
urn35731462_urn
warn75239322warn
won66252062wo_n
word89832002word
wore77144672wore
work115528842work
worm96129482worm
wort76654752wort
yarn75230042yarn
yon67348952yo_n
yore76335942yore
yourn87512772yourn
zoon137326982zoon
zori137722922zori

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 Filter178691298720.0762351197.4
2DLD Change Limit298723251.01629401.6
3Display Results3253250.0804062.5
 (SQL Overall)1786913251.172152466.7
 
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.