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 “adorner” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

270 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
adorner824697(None) 
adorer74713441ador_er
adorned9256881adorned
adorners9196611adorners
aborter939922aborter
acorned10238262acorned
adopter1036752adopter
adore65723662ador_e_
adored84714232ador_ed
adorers84411722ador_ers
adores74420712ador_es
adorn64917092adorn__
adorns74212612adorn_s
adsorber1143492adsorber
atoner64817192ato_ner
corner84625622_corner
darner74017302_darner
dormer94415892_dormer
dorper94314562_dorper
dorser74819172_dorser
downer104414922_downer
droner74717672_droner
scorner9259762scorner
sorner64720382_sorner
abhorrer1343383abhorrer
aborted10310423aborted
aborters1038563aborters
absorber1254303absorber
accorder1395223accorder
acerber1135233acerber
acorn75616623acorn__
acorns85013013acorn_s
adapter1036173adapter
adder75419593ad__der
adducer1184163adducer
adepter1036113adepter
adherer1137563adherer
adjoined1743513adjoined
adjourned1842063adjourned
adjurer1534803adjurer
admirer1035513admirer
adobe84814703ado_be_
adobes94411523ado_bes
adonis7314063ado_nis
adopted1136253adopted
adoptee1048413adoptee
adopters1136683adopters
adoring9412523adoring
adorning1087323adorning
adornment1246273adornment
adown95611663adown__
adoze155713833ado_ze_
adroiter946183adroiter
adsorbed1243433adsorbed
adsorbers1243253adsorbers
advancer1443483advancer
adviser11135783adviser
aerier64823153a_erier
afore85818603afor_e_
aginner844663aginner
agone65924553ago_ne_
agones75719863ago_nes
agorae7511203agorae_
ahorse9311513ahorse_
airer54927893a_ir_er
airier64619363a_irier
alerter72111513alerter
aliener71011193aliener
aligner8108313aligner
aliner65621983a_liner
almner85710723a_lmner
almoner949383almoner
alone55732963alo_ne_
amercer1146373amercer
angrier839023angrier
anointer837823anointer
another10289153another
aproned10311503aproned
armer76924443a__rmer
armorer9259903armor_er
arouser74514423arouser
assorter866663assorter
atone56527983ato_ne_
atoned75417543ato_ned
atoners75013953ato_ners
atones65225773ato_nes
attorned955353attorned
attorney1173723attorney
averter102410553averter
avoider1155813avoider
avower1236823avo_wer
awarder1135893awarder
axone125918473axo_ne_
axones134614513axo_nes
boner75133083_bo_ner
border94419973_border
borer75131273_bor_er
borne77926793_borne_
browner124911643browner
burner83819203_burner
cavorter1335783cavorter
churner12298343churner
cloner84418093clo_ner
coiner84323783_coiner
conner84423963_conner
corder94322873_corder
corer75538873_cor_er
corker124720853_corker
cornea84018923_cornea
corned95224523_corned
cornel84020053_cornel
corners94723313_corners
cornet84436733_cornet
cornier93017083_cornier
coroner94218203_coroner
crooner93714043crooner
crowner124012593crowner
damner95213433_damner
darer65230793_dar_er
darker114718693_darker
darned85018483_darned
darnel74312183_darnel
darners83815773_darners
darter75320363_darter
dehorner1235523dehorner
dernier83011943_dernier
diner65632903_d_iner
dinner74217163_dinner
direr64927073_dir_er
dobber114015413_dobber
docker134417653_docker
dodder94712913_dodder
dodger95817043_dodger
doer57734703_do__er
doffer133911353_doffer
dogger95216783_dogger
done55747913_do_ne_
donee66931013_do_nee
donne65520463_donne_
donned85015743_donned
donnee74317063_donnee
donnerd9427813_donnerd
donnert82815523_donnert
donor64418193_do_nor
doozer163910463_doozer
doper86128393_do_per
dopier93515923_dopier
dore56353303_dor_e_
dories75232363_dories
dorkier122810023_dorkier
dormers104313913_dormers
dorneck1444303_dorneck
dorpers104113163_dorpers
dorr56627723_dor__r
dorsel75315503_dorsel
dorsers83516293_dorsers
doser66228563_do_ser
dosser74417973_dosser
doter65428623_do_ter
dotier73917033_dotier
dotter74419343_dotter
dourer74215273_dourer
douser75621633_douser
dower95027703_do_wer
downed115314783_downed
downers113912773_downers
downier11299703_downier
dowser104716083_dowser
dozer158419273_do_zer
dozier163611633_dozier
drier64423963_d_rier
drone65324983_drone_
droned84616863_droned
droners84114383_droners
drones75023433_drones
drover104614593_drover
drowner11369803drowner
dryer95111463_d_ryer
dunner73913823_dunner
durned84113173_durned
earner63617223_earner
eloiner7149183eloiner
endorser966733endorser
favorer1355883favor_er
forcer114917343_forcer
forger104820773_forger
forker134717903_forker
former114221403_former
frowner13429683frowner
garner73917003_garner
goner66025163_go_ner
gorger86116983_gorger
gorier73719373_gorier
groaner82510133groaner
honer85332093_ho_ner
horned105718703_horned
hornet94926433_hornet
hornier103012453_hornier
indorser985713indorser
ironer64216453iro_ner
joiner134114133_joiner
kroner104612573kro_ner
laborer9249503labor_er
ladrone83611873ladrone_
ladrones92710973ladrones
landowner1343663landowner
learner7319383learner
loaner64416503_loaner
loner55431043_lo_ner
loriner7511883_loriner
madrone102812663madrone_
madrones112912283madrones
moaner84415113_moaner
moderner1145523moderner
mooner85317833_mooner
moorier93113073moorier
mourner938083mourner
odored8399223odor_ed
order65019363__order
ormer75218373__ormer
ornery938463__ornery
owner84613313__owner
padrone102512073padrone_
padrones112711043padrones
pardoner11189443pardo_ner
poorer82613993poor_er
porker124917543_porker
pornier93413123_pornier
porter84224413_porter
ratooner886993ratooner
readorned1145183readorned
reorder8239483reorder
savorer1057883savor_er
savorier1136643savorier
scorer84818253scor_er
scorned10229953scorned
scorners10228493scorners
shorter103515493shorter
snorer64316763snor_er
snorter74412653snorter
sooner64220463_sooner
sorer56236573_sor_er
sorned74820043_sorned
sorners73416863_sorners
sorter64425083_sorter
sporter93616553sporter
spurner9269653spurner
sterner7411913sterner
stoner65823203sto_ner
storer64721673stor_er
suborner1047383suborner
swooner10358673swooner
taborer9269293tabor_er
taverner1134423taverner
thorned11479403thorned
thornier1135323thornier
toner55336243_to_ner
tonner64819203_tonner
turner63914613_turner
unadorned1144123unadorned
vaporer1236983vapor_er
wagoner1136093wago_ner
warner93717223_warner
wonner95114443_wonner
worker134715113_worker
wormer114514913_wormer
worser95117523_worser
yarner93313063_yarner
yearner10336873yearner
zoner144520343_zo_ner

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272707.03319056.9
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.28224538.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.