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

276 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
corse7503618(None) 
carse74934331carse
coarse84813891coarse
copse95623921copse
core67263111cor_e
cores76361851cores
corpse104013401corpse
cors66656441cors_
corses84433461corses
corset85636221corset
course85117771course
curse75829141curse
gorse65926811gorse
horse86132651horse
morse76032701morse
torse55833331torse
worse86525261worse
ahorse9311512ahorse
arose55832082arose
arse46539272_arse
birse74517402birse
bore66051332bor_e
bores76448252bores
borne77926792borne
bourse84414332bourse
bouse75931852bouse
bowse105420632bowse
brose75227032brose
burse75527252burse
care66968372car_e
cares77369182cares
carle74535702carle
cars67364762cars_
carses85233652carses
carte75940422carte
carve106227752carve
case65848082c_ase
cause75225352cause
cease75227652cease
cense75121402cense
cere66741472cer_e
ceres75540012ceres
cerise84822042cerise
ceruse83914522ceruse
chase105127122chase
choose115116142choose
chore105126762chor_e
chores114828022chores
chose105925402chose
chouse116017562chouse
chowse144711752chowse
cire65836372cir_e
cires74932912cires
close76425222close
coarsen93210322coarsen
coarser93211192coarser
coast75236262coast
coble94823172coble
cobs87043142cobs_
code77347732co_de
codes86247292codes
cods76848102cods_
coerce10310402coerce
cogs77340032cogs_
coirs75221052coirs_
coke107038382co_ke
cokes115537192cokes
cole66956112co_le
coles76055062coles
cols66553082cols_
comae97128422comae
combe116223542combe
come87547702co_me
comes97246992comes
comose105016842comose
comte96125472comte
cone67256962co_ne
cones76457422cones
conge85227592conge
cons66057692cons_
conte76633202conte
cooee74531022cooee
coos67456492coos_
cope86847382co_pe
copes97747102copes
cops86751372cops_
copses104922472copses
cor59960942cor__
coral76033452coral
corbel103715972corbel
corbie103618202corbie
corby125018532corby
cord76740922cor_d
corded105923352corded
corder94322872corder
cords86030622cords
cored85044222cored
corer75538872corer
corf95941482cor_f
corgi8316082corgi
coria75828302coria
cork106635692cor_k
corked135020782corked
corker124720852corker
corks116028272corks
corky145221152corky
corm85735372cor_m
cormel103815602cormel
corms95626222corms
corn69945812cor_n
cornea84018922cornea
corned95224522corned
cornel84020052cornel
corner84625622corner
cornet84436732cornet
corns76034762corns
cornu75921322cornu
corny106023272corny
corps95927042corps
corpses113913802corpses
corrie83621212corrie
corsac10410172corsac
corsage1039802corsage
corsets94819802corsets
corslet9318062corslet
cortex15311462cortex
corvee114320092corvee
corves115122522corves
corvet114626932corvet
cory96941512cor_y
cos510270392co_s_
cosec96320182co_sec
coses76949492co_ses
coset75748842co_set
cosey106226712co_sey
cosh96127622co_sh
cosie74728262cosie
coss66143492co_ss
cosset84125862cosset
cost68057942co_st
cosy97232702co_sy
cote66648732co_te
cotes76347842cotes
cots68054842cots_
coude85022632coude
coupe96023482coupe
coursed104113602coursed
courser94114802courser
courses94218892courses
cove95837072co_ve
coves105539172coves
cowrie113814272cowrie
cows97046642cows_
coxae146115182coxae
coxes145430862coxes
coys97537242coys_
cozes166033242cozes
cozie163519122cozie
crone75231332crone
crore74922862crore
crores86121162crores
cross75124502cross
crosse85216302crosse
crouse84619362crouse
croze164719452croze
cruse75726102cruse
cure66149122cur_e
cures75645432cures
curie74533032curie
curs65645542curs_
cursed94321252cursed
curser84721472curser
curses85328272curses
curst74931022curst
curve104920022curve
dore56353302dor_e
dors56747602dors_
dorsa64617282dorsa
dorsel75315502dorsel
dorser74819172dorser
dose56442432do_se
douse66329722douse
dowse96020812dowse
erose55727272erose
force105324272force
fore78351472for_e
fores85847102fores
forge95126942forge
forme105225992forme
forte86131462forte
fosse86119462fosse
goose65925902goose
gore55744962gor_e
gores65740372gores
gorge76423892gorge
gorses74723292gorses
gorsy95915782gorsy
hoarse94411322hoarse
hoise85224772hoise
horde94623052horde
horsed105321082horsed
horses94729342horses
horsey125115402horsey
horst85833512horst
horste94817412horste
horsy116318392horsy
hose76547242ho_se
house89131422house
kore85834162kor_e
kors85933012kors_
loose56627682loose
lore45850352lor_e
lores55045402lores
lose45144582lo_se
louse56131012louse
lowse87219902lowse
marse76231152marse
moose76327192moose
morae75831192morae
more67154522mor_e
mores76249642mores
morose85116242morose
mors65950062mors_
morsel85815892morsel
mouse77133002mouse
noise55723732noise
noose55624062noose
nose46739362no_se
nurse54420122nurse
oorie53026362oorie
ore36661832_or_e
ores46056682_ores
orle45630462_orle
ors35750112_ors_
ose38147342_o_se
owse76321622_owse
parse75236992parse
perse75429522perse
poise75127892poise
pore66451262por_e
pores75849032pores
porose84818742porose
pose66441732po_se
posse74722272posse
prose75835122prose
purse76028892purse
roose56127092roose
rose46148902ro_se
rouse56634702rouse
score75526732scor_e
scores84725922scores
scouse84113632scouse
sore47059532sor_e
sores55454282sores
souse56530772souse
terse55026822terse
tore47359322tor_e
tores55352672tores
torose64317692torose
tors46157382tors_
torses64727952torses
torsi57423362torsi
torsk94915772torsk
torso56922142torso
torte55431702torte
touse55430672touse
verse84723582verse
wore77144672wor_e
worsen95513872worsen
worser95117522worser
worses95522952worses
worset96726582worset
worst86330132worst
yore76335942yor_e
yores85031322yores
youse85322232youse

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 Filter178691538000.0931921408.6
2DLD Change Limit538002761.82629463.3
3Display Results2762760.0803450.0
 (SQL Overall)1786912761.99989390.2
 
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.