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

217 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
horse8613265(None) 
ahorse9311511ahorse
corse75036181corse
gorse65926811gorse
hoarse94411321hoarse
hoise85224771hoise
horde94623051horde
horsed105321081horsed
horses94729341horses
horsey125115401horsey
horst85833511horst
horste94817411horste
horsy116318391horsy
hose76547241ho_se
house89131421house
morse76032701morse
torse55833331torse
worse86525261worse
arose55832082arose
arse46539272_arse
birse74517402birse
bore66051332bor_e
bores76448252bores
borne77926792borne
bourse84414332bourse
bouse75931852bouse
bowse105420632bowse
brose75227032brose
burse75527252burse
carse74934332carse
choose115116142choose
chore105126762chor_e
chores114828022chores
chose105925402cho_se
chouse116017562chouse
chowse144711752chowse
coarse84813902coarse
copse95623922copse
core67263112cor_e
cores76361852cores
corpse104013402corpse
cors66656442cors_
corses84433462corses
corset85636222corset
course85117782course
curse75829142curse
dore56353302dor_e
dors56747602dors_
dorsa64617282dorsa
dorsel75315502dorsel
dorser74819182dorser
dose56442432do_se
douse66329722douse
dowse96020812dowse
erose55727272erose
force105324272force
fore78351472for_e
fores85847102fores
forge95126942forge
forme105225992forme
forte86131462forte
fosse86119462fosse
goose65925902goose
gore55744962gor_e
gores65740372gores
gorge76423892gorge
gorses74723292gorses
gorsy95915782gorsy
hanse85722792hanse
hare76255732har_e
hares86255542hares
harsh116418052harsh
hawse116015122hawse
hearse94114272hearse
here76447102her_e
heres86245902heres
hers75844872hers_
hire75538962hir_e
hiree85427802hiree
hires86134342hires
hirsel9138682hirsel
hirsle9159572hirsle
hoars85925552hoars_
hoarsen10367992hoarsen
hoarser10388392hoarser
hobs97038982hobs_
hods87239862hods_
hoe67562722ho__e
hoers85724922hoers_
hoes75755732hoes_
hogs87139662hogs_
hoised105117432hoised
hoises94823672hoises
hoist86433212hoist
hoke115935932ho_ke
hokes126231642hokes
hole77553392ho_le
holes84748652holes
hols76946292hols_
home98042442ho_me
homes106938812homes
homie104622532homie
hone77549322ho_ne
hones88144492hones
hons77350782hons_
hope96639672ho_pe
hopes105835642hopes
hops97942632hops_
hora76136562hor_a
horah117922052horah
horal86328682horal
horas86333102horas
horded115420482horded
hordes104921632hordes
horn76735612hor_n
horned105718702horned
hornet94926432hornet
horns86125332horns
horny115619622horny
horsier103013242horsier
horstes104516112horstes
horsts95817512horsts
hos68364192ho_s_
hosed95830982ho_sed
hosel86024812ho_sel
hosen85623882ho_sen
hoser811529762ho_ser
hoses85443172ho_ses
hosey116127022ho_sey
host77852832ho_st
hots78349332hots_
hours85422392hours_
housed105624102housed
housel95217042housel
houser95322282houser
houses96032272houses
hove107132222ho_ve
howe106734102ho_we
howes114730262howes
hows106345602hows_
hoyle11314412hoyle
hoys107733932hoys_
hurst85527192hurst
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
shore85432652shor_e
shores94830412shores
sore47059532sor_e
sores55454282sores
souse56530772souse
terse55026822terse
thorpe113610092thorpe
those85218142tho_se
thyrse1235132thyrse
tore47359322tor_e
tores55352672tores
torose64317692torose
tors46157382tors_
torses64727952torses
torsi57423362torsi
torsk94915772torsk
torso56922142torso
torte55431702torte
touse55430672touse
unhorse1038582unhorse
verse84723582verse
whore116018042whor_e
whores125617102whores
whose114914532who_se
wore77144672wor_e
worsen95513872worsen
worser95117522worser
worses95522952worses
worset96726582worset
worst86330132worst
yore76335942yor_e
yores85031322yores
youse85322232youse

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 Limit538002171.75030742.9
3Display Results2172170.0633444.4
 (SQL Overall)1786912171.90693751.8
 
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.