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

290 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
sorns5502841(None) 
corns76034761corns
horns86125331horns
morns75527441morns
porns75527341porns
scorns85713011scorns
sons46049551so_ns
soras55041011soras
sorbs75022101sorbs
sords64527801sords
sores55454281sores
sorn46641061sorn_
sorts54536661sorts
sorus54527581sorus
acorns85013012acorns
adorns74212612adorns
airns55521032airns
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
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ornis54616772_ornis
ors35750112_or_s
orts46538332_orts
owns76819582_owns
pirns76020092pirns
pons65850602po_ns
poons75430972poons
pores75849032pores
porks115124142porks
porn65636022porn_
porno75120652porno
pornos85015252pornos
porny106020192porny
ports75934592ports
roans54926442roans
sains55639972sains
sans45153352s_ans
sarans64224432sarans
sards64736182sards
sarins63932622sarins
saris54544952saris
sarks96632462sarks
saros55238062saros
scans74625102scans
scores84725922scores
scorn75817442scorn_
seres55448892seres
serfs84922012serfs
serins64029672serins
sers45746652ser_s
sharns95516982sharns
shins85131042shins
shorans102812402shorans
shores94830402shores
shorls94516192shorls
shorn85722172shorn_
shorts95321732shorts
shris84221442shris
shuns85018142shuns
signs65516322signs
sins46755272s_ins
sirens65318152sirens
sires55945372sires
sirs44338332sir_s
skins94723462skins
skorts104211292skorts
snores64324312snores
snorts64116492snorts
soaks95220292soaks
soaps75120712soaps
soars54732512soars
sobas74424252sobas
sobs64941752so_bs
socas74026182socas
socks114926082socks
sodas64123542sodas
sods54940212so_ds
sofas85320712sofas
softs85019232softs
soils55327982soils
sojas124716392sojas
sokes95031422sokes
solans64122492solans
soles55547922soles
solons65120012solons
solos54830792solos
sols45448162so_ls
solus54726982solus
somans84619302somans
somas76030372somas
soms66239372so_ms
son37761952so_n_
sone46649982so_ne
sones55444142sones
song55133672so_ng
songs67725552songs
sonny85016102sonny
sonsy86416372so_nsy
sooks94425452sooks
soon46240502soon_
soots55536202soots
sophs104916022sophs
sops65244562so_ps
sora45746912sor_a
sorb68333042sor_b
sord56237202sor_d
sore47059532sor_e
sored66141782sored
sorel56231442sorel
sorels63921162sorels
sorer56236572sorer
sorest65027992sorest
sorgo64719722sorgo
sorgos74514662sorgos
sori46039832sor_i
soring74731882soring
sorings83817252sorings
sorned74820042sorned
sorner64720382sorner
sorners73416862sorners
sorry84618252sorry
sort46264812sor_t
sorta57125412sorta
sos37761602so__s
soths86218622soths
sots45552442so_ts
souks94820522souks
souls55127362souls
sound64420022sound
sounds74616182sounds
soups75322942soups
sours55230502sours
sous46947212so_us
sovrans1036482sovrans
sowans94215892sowans
sowens93613152sowens
sown75127452sown_
sows75342492so_ws
soyas84520912soyas
soys75233932so_ys
sozins15510782sozins
spans74528732spans
spins75327982spins
spoons84116012spoons
spores84726612spores
sports84619182sports
spurns84811382spurns
sris45434152s_ris
sterns64616752sterns
stores65533642stores
storks106115932storks
storms85814602storms
stuns54719492stuns
suborns939482suborns
sunns55017352sunns
suns45841902s_uns
suras55336322suras
surds65624662surds
surfs85022542surfs
swans84625012swans
swoons94511142swoons
swords104510792swords
sworn86115302sworn_
swouns9358242swouns
syrens94911992syrens
tarns56433952tarns
terns55226872terns
thorns95314092thorns
tons46553052to_ns
toons55027532toons
toras55540372toras
torcs75123762torcs
tores55352672tores
torn46044252torn_
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
towns86018882towns
tsores65113662tsores
tsoris63411192tsoris
turns55623232turns
urns46323892_urns
warns87231002warns
wons74942042wo_ns
words95425072words
works125621902works
worms105320752worms
worn75631752worn_
worts88631182worts
yarns85621792yarns
yores85031322yores
zoons144919692zoons
zoris145320012zoris

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.0931921408.6
2DLD Change Limit538002901.67032215.6
3Display Results2902900.0803625.0
 (SQL Overall)1786912901.84396956.6
 
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.