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

154 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
corners9472331(None) 
coiners93620751coiners
conners94023111conners
corders104520881corders
corers85231071cor_ers
corkers134118851corkers
corneas94717001corneas
cornels94716661cornels
corner84625621corner_
cornets94820571cornets
coroners104016221coroners
scorners10228491scorners
sorners73416871sorners
adorners9196622adorners
boners84825432bo_ners
borders104317532borders
borers85122682bor_ers
burners94115672burners
caners84629202c_aners
canners93822662canners
carders104820352carders
careers95218782careers
carers85133962car_ers
carnets93918402carnets
carneys124310542carneys
carpers114521252carpers
carters95327252carters
carvers124817532carvers
churners13316892churners
cloners94514822cloners
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
cobbers134114752cobbers
cockers153618332cockers
codders114114452codders
coders95426982co_ders
codgers115113932codgers
coercers1237652coercers
coffers154112692coffers
coilers93619902coilers
coiner84323782coiner_
coinfers13349502coinfers
cointers103616412cointers
colters93522442colters
combers134516622combers
comers105328082co_mers
cones76457422co_ne_s
coneys115218422co_neys
confers124120092confers
congers104223232congers
conkers133721042conkers
conner84423962conner_
cooers84324562co_oers
cookers134619462cookers
coolers93522492coolers
coopers114019482coopers
cooters94525722cooters
copers104629842co_pers
copiers114215962copiers
coppers133519752coppers
copters113621282copters
corbels113813592corbels
corder94322882corder_
corer75538872cor_er_
cores76361852cor_e_s
corker124720852corker_
cormels113813372cormels
cornea84018922corne_a
corneal94414502corneal
corned95224522corne_d
cornel84020052corne_l
corneous10310032corneous
cornered11311132cornered
cornet84436732corne_t
cornier93017092cornier_
corns76034762corn__s
cornus84816562corn_us
coronels104012142coronels
coroner94218202coroner_
coronets103814362coronets
corses84433462corse_s
corsets94819802corsets
corulers1039772corulers
corvees124613792corvees
corves115122522corve_s
corvets124715022corvets
coshers123618182coshers
costers94128332costers
cotters94323442cotters
counters103320192counters
couriers103213172couriers
coursers104412302coursers
courters103015372courters
couters93827302couters
covers114627962co_vers
cowers114625532co_wers
coyness1277322coyness
cozeners19297782cozeners
criers83918582c_riers
crones84729242crone_s
crooners103911392crooners
crowers124614902crowers
crowners133710752crowners
crozers184111082crozers
cunners93913472cunners
curbers115514382curbers
curers84923192cur_ers
curlers94218072curlers
cursers94317162cursers
darners83815772darners
dormers104313922dormers
dorpers104113172dorpers
dorsers83516302dorsers
downers113912772downers
droners84114382droners
earners74016452earners
forcers124215712forcers
forgers115218182forgers
forkers144615782forkers
formers128217952formers
garners83815982garners
goners74420172go_ners
gorgers94813642gorgers
honers94324972ho_ners
hornets104113552hornets
ironers74813552ironers
joiners144211572joiners
loaners73913622loaners
loners64225812lo_ners
loriners839962loriners
moaners92813552moaners
mooners94015342mooners
mourners1036912mourners
orders74315992_orders
ormers84316142_ormers
ornery938462_ornery
owners94210702_owners
porkers134314932porkers
porters93722702porters
scorers94115322scor_ers
scorner9259762scorner_
sooners73916642sooners
sorner64720392sorner_
sorters74221132sorters
toners64128002to_ners
tonners73816402tonners
turners73912892turners
warners103315562warners
wonners104312812wonners
workers144612692workers
wormers124012572wormers
yarners104312202yarners
zoners155115992zo_ners

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711543.39031761.4
3Display Results1541540.0463347.8
 (SQL Overall)1786911543.81246875.9
 
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.