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

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
sorcery123703(None) 
forcer114917342forcer_
forcers124215712forcers
forgery14419302forgery
grocery13336762grocery
mercery14397622mercery
ornery938462_ornery
orrery936782_orrery
soccer1038542soccer_
soccers1138392soccers
sorcerer1036432sorcerer
sorely94618012sor_ely
sorer56236592sor_er_
sorner64720392sorner_
sorners73416872sorners
sorry84618252sor__ry
sorter64425092sorter_
sorters74221132sorters
spicery14499012spicery
surgery11319212surgery
archery15478063_archery
artery9911453_artery
bobbery13438353bobbery
bootery1238983bootery
border94419973border_
borders104317533borders
borer75131273bor_er_
borers85122683bor_ers
botchery18366763botchery
bowery146012113bo_wery
briery114510773_briery
coercer1138383coercer_
coercers1237653coercers
concern113011963concern
concert113325223concert
cookery164210393cookery
coopery143910273coopery
coppery16409393coppery
corder94322883corder_
corders104520883corders
corer75538873cor_er_
corers85231073cor_ers
corker124720853corker_
corkers134118853corkers
corner84625623corner_
corners94723313corners
corsetry1365573corsetry
crockery19356603crockery
doddery13516853doddery
dodgery13627783dodgery
doggery13448263doggery
dormer94415903dormer_
dormers104313923dormers
dorper94314573dorper_
dorpers104113173dorpers
dorser74819183dorser_
dorsers83516303dorsers
doucely1344883doucely
dowery134311663do_wery
farcer115016083farcer_
farcers124713443farcers
fernery1335813fernery
foolery1336693foolery
foppery17385623foppery
force105324273force__
forced126316523force_d
forcedly1744803forcedly
forceps14466983forceps
forces114422133force_s
foreby1438633for_eby
forger104820773forger_
forgers115218183forgers
forker134717903forker_
forkers144615783forkers
former114221403former_
formerly1645003formerly
formers128217953formers
gorger86116983gorger_
gorgers94813643gorgers
gorier73719373gorier_
grocer94212143grocer_
grocers103511253grocers
horary12310383hor_ary
horsey125115403horse_y
hosiery13337183hosiery
jobbery21366013jobbery
joinery17366593joinery
larceny1234853larceny
lorry86315673lor__ry
lottery10389833lottery
lowery124112713lo_wery
mercer105214203mercer_
mercers114412773mercers
mercury14364893mercury
mockery18376913mockery
monkery16317453monkery
mopery135210973mo_pery
morceau1145573morceau
mortary12369043mortary
mothery153710513mothery
nursery10396023nursery
ochery14319443_ochery
ochry13346933_o_chry
onery8414123_o_nery
orcein838183_orcein
order65019363_order_
orderly1135763_orderly
orders74315993_orders
ormer75218373_ormer_
ormers84316143_ormers
popery134511703po_pery
porker124917543porker_
porkers134314933porkers
porter84224413porter_
porters93722703porters
pottery123011073pottery
powdery16396123powdery
robbery14348283robbery
rockery16439253rockery
roguery1134893roguery
rookery14398313rookery
ropery114313873ro_pery
rosery93813283ro_sery
saucer84314103saucer_
saucers93712133saucers
scarcely1534313scarcely
scarcer113911373scarcer_
scary105222593s__cary
scenery1236563scenery
scorcher15196783scorcher_
scorchers16145513scorchers
scorer84818263scor_er_
scorers94115323scor_ers
scorner9259763scorner_
scorners10228493scorners
screwy14659463scr_ewy
scry96017763s__c_ry
sealery104011053sealery
secern81010223s_ecern
secrecy1444743secrecy
serer55935513ser_er_
serger73819743serger_
sergers83815633sergers
serry84824123ser__ry
server94917713server_
servers103214833servers
shivery16317023shivery
shorter103515503shorter_
showery16437243showery
shrieky17364803shrieky
silvery13328093silvery
sincere9310553sincere
slavery13407893slavery
slicer84117603slicer_
slicers94114923slicers
slobbery15375663slobbery
smothery16296063smothery
sneery93610413s_neery
snickery17295543snickery
snobbery15514293snobbery
snorer64316763snor_er_
snorers74313803snor_ers
snorter74412663snorter_
snorters83410583snorters
soaker105717533soaker_
soakers114114953soakers
soaper84517873soaper_
soapers93715923soapers
soarer64522243soarer_
soarers74118093soarers
sobber104016593sobber_
sobbers114114263sobbers
sober74822413so_ber_
soberly1236943so_berly
sobers85218863so_bers
sobriety1343903sobriety
society1236083society
soever94412093soever_
softer94015313softer_
solacer93011103solacer_
solacers10268893solacers
solder73921343solder_
solders83517773solders
soldiery12254613soldiery
solely93714213so_lely
solver94016703solver_
solvers104414253solvers
somber103714003somber_
somberly1544053somberly
sonder73623523sonder_
sonders83820713sonders
sooey84522433so_oe_y
sooner64220463sooner_
sooners73916643sooners
sorbed94916523sorbe_d
sorbent92915243sorbent
sorbet83924083sorbe_t
sorbets93012513sorbets
sorcerers1145323sorcerers
sorceress1144013sorceress
sorceries1149933sorceries
sorcerous1145913sorcerous
sordor7310223sordor_
sordors8310013sordors
sore47059533sor_e__
sored66141783sor_e_d
sorel56231443sor_e_l
sorels63921163sor_els
sores55454283sor_e_s
sorest65028003sor_est
sorned74820043sorne_d
sorrel6413553sorre_l
sorrels7310723sorrels
sorrier72313733sorrier_
sorrily1039833sorrily
sorted74523713sorte_d
soucar839323soucar_
soucars938423soucars
source8410673source__
sourced1038453source_d
sources9312173source_s
sourer63620213sourer_
souter64225923souter_
souters74422603souters
sowcar1135863sowcar_
sowcars1236013sowcars
sower85229313so_wer_
sowers94923443so_wers
spacer104917793spacer_
spacers113813873spacers
spacey136212533space_y
sphery14318883s_phery
spicer104719313spicer_
spicers113815553spicers
spicey134414233spice_y
spidery13308203spidery
spoofery16354313spoofery
spookery17264143spookery
sporter93616553sporter_
sporters103714063sporters
sprier84119063sprier_
sprucely1543123sprucely
sprucer11317683sprucer_
spryer11418533spryer_
storer64721673stor_er_
storers75018683stor_ers
storey95217613stor_e_y
succory1444643succory
summery14329413summery
surely93816463sur_ely
surer54833103sur_er_
surety93515013sur_ety
surfer93515883surfer_
surfers103614133surfers
surger74320093surger_
surgers83517483surgers
surrey94414583surre_y
survey124111673surve_y
toggery12505923toggery
torchere1347683torchere
torchy14549533torc_hy
torero6313203tor_ero
torrefy1353353torrefy
tottery10388483tottery
towery124012093to_wery
tracery12399793tracery
turnery10357423turnery
voicer113910543voicer_
voicers12348993voicers
volery1237873vo_lery
worker134715113worker_
workers144612693workers
wormer114514913wormer_
wormers124012573wormers
worry116114333wor__ry
worser95117523worser_

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.406440125.6
2DLD Change Limit1340272766.84619577.4
3Display Results2762760.1062603.8
 (SQL Overall)1786912767.35824285.3
 
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.