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

266 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
doddery1351685(None) 
dodder94712911dodder_
dodders105511791dodders
dodgery13627781dodgery
codder104416342codder_
codders114114452codders
doddered1234942doddered
dodderer1144202dodderer
dodger95817042dodger_
dodgers105213822dodgers
doggery13448262doggery
dowery134311662do_wery
fodder114712112fodder_
fodders124010752fodders
nodder84811942nodder_
nodders94410262nodders
odder74515392_odder_
powdery16396122powdery
adder75419593_adder_
adders84315703_adders
badder103817513badder_
bedder104215783bedder_
bedders113513383bedders
bidder104114863bidder_
bidders114012313bidders
bindery13459833bindery
bladdery15344583bladdery
bobbery13438353bobbery
bolder94820933bolder_
bonder95324783bonder_
bonders104120663bonders
bootery1238983bootery
border94419973border_
borders104317533borders
bouldery14295013bouldery
bowery146012113bo_wery
broidery14356083broidery
budder104314813budder_
budders113812103budders
cindery13429193cindery
codded114515303codde_d
coddler113710833coddler_
coddlers12359173coddlers
coder86134223co_der_
coders95426983co_ders
codger105814853codger_
codgers115113933codgers
colder95121843colder_
cookery164210393cookery
coopery143910273coopery
coppery16409393coppery
corder94322883corder_
corders104520883corders
daddy116212563dadd__y
dander811222993dander_
danders93921183danders
daubery13396213daubery
deader84220473deader_
deanery1137613deanery
diddler103511513diddler_
diddlers11359153diddlers
diddley13388103diddley
diddly12389573didd_ly
dithery14318943dithery
dobber114015423dobber_
dobbers123513253dobbers
docker134417653docker_
dockers143715003dockers
dodderers1243803dodderers
doddering1335183doddering
dodge86618123dodge__
dodged107514683dodge_d
dodgem116710033dodge_m
dodgems12576443dodgems
dodges96119073dodge_s
dodgier10388243dodgier_
dodgy116611463do_d_gy
dodoes85716103dodoe_s
doer57734703do__er_
doers65225713do__ers
doffer133911353doffer_
doffers14359853doffers
dogberry1542863dogberry
dogey105719513do_ge_y
dogger95216783dogger_
doggers104413433doggers
donkey14449733donke_y
donnerd9427813donnerd
donnert82815533donnert
doodler93310153doodler_
doodlers10338843doodlers
doody105517913dood__y
doozer163910463doozer_
doozers17419293doozers
doper86128393do_per_
dopers95522483do_pers
dopey116020353do_pe_y
dopier93515923dopier_
dormer94415903dormer_
dormers104313923dormers
dorper94314573dorper_
dorpers104113173dorpers
dorser74819183dorser_
dorsers83516303dorsers
dory85836233do___ry
doser66228563do_ser_
dosers75723633do_sers
dosser74417973dosser_
dossers84516233dossers
doter65428623do_ter_
doters74423913do_ters
dotier73917033dotier_
dotter74419343dotter_
dotters83715973dotters
doucely1344883doucely
dourer74215273dourer_
douser75621633douser_
dousers84817273dousers
dowdier12328573dowdier_
dowdily1534953dowdily
dowdy136112543dowd__y
dower95027703do_wer_
dowers104523293do_wers
downer104414923downer_
downers113912773downers
dowry126312483do__wry
dowser104716083dowser_
dowsers115013533dowsers
doyley13487283doyle_y
dozer158419273do_zer_
dozers164815423do_zers
dozier163611633dozier_
drapery13387943drapery
drollery12314793drollery
drudgery14273633drudgery
duddy114911033dudd__y
dupery12378743d_upery
foddered1434553foddered
folder104317543folder_
folders113514393folders
fonder104120063fonder_
foolery1336693foolery
foppery17385623foppery
forgery14419303forgery
gadder93714713gadder_
gadders103611503gadders
gaudery1234743gaudery
godded104811803godde_d
goddess1035263goddess
golder84417603golder_
hodden113811453hodde_n
hoddens12378803hoddens
holder104619653holder_
holders113715903holders
hosiery13337183hosiery
jobbery21366013jobbery
joinery17366593joinery
judder15439423judder_
judders16347793judders
kidder123811093kidder_
kidders13399173kidders
ladder84617623ladder_
ladders94115173ladders
loader74316313loader_
loaders83413433loaders
lodger86517683lodger_
lodgers95113833lodgers
lottery10389833lottery
louder74414603louder_
lowery124112713lo_wery
madder103515593madder_
madders113513213madders
mockery18376913mockery
modern939523mo_dern
molder93819273molder_
molders103315553molders
monkery16317453monkery
mopery135210973mo_pery
mothery153710513mothery
mudder104413493mudder_
mudders113211113mudders
nodded94012123nodde_d
noddy105411203nodd__y
ochery14319443_ochery
oddest81710863_oddest
oddity1135243_oddity
oddly1037163_odd_ly
older65121173_older_
onery8414123_o_nery
order65019363_order_
orderly1135763_orderly
orders74315993_orders
ornery938463_ornery
orrery936783_orrery
padder103415493padder_
padders113312873padders
peddlery15224003peddlery
pedlery13297073pedlery
plodder1146003plodder_
plodders1235523plodders
podded115012713podde_d
polder94019253polder_
polders103617373polders
ponder94521693ponder_
ponders103618843ponders
popery134511703po_pery
pottery123011073pottery
powder123611903powder_
powders134111553powders
prodder1147953prodder_
prodders1237463prodders
prudery1335243prudery
redder83918133redder_
redders93615343redders
ridder84015143ridder_
ridders93612493ridders
robbery14348283robbery
rockery16439253rockery
rodded93713703rodde_d
roguery1134893roguery
rookery14398313rookery
ropery114313873ro_pery
rosery93813283ro_sery
rudder83812803rudder_
rudders93210653rudders
rudery10419033_rudery
sadder82916973sadder_
saddlery13274913saddlery
shuddery16263413shuddery
sodded94113303sodde_d
sodden84011513sodde_n
soddenly1343783soddenly
soddens9348413soddens
soddy104210703sodd__y
solder73921343solder_
solders83517773solders
soldiery12254613soldiery
sonder73623523sonder_
sonders83820713sonders
sorcery1237033sorcery
spidery13308203spidery
tedder83312153tedder_
tedders94010233tedders
tindery11389363tindery
toddler9379043toddler_
toddlers10346963toddlers
toddy106812423todd__y
toggery12505923toggery
tottery10388483tottery
towery124012093to_wery
udder76314283_udder_
udders83911293_udders
voider103611553voider_
voiders11279823voiders
volery1237873vo_lery
wadder114215483wadder_
wadders123812443wadders
wedder113612293wedder_
wedders123610723wedders
widder112913973widder_
widders123512273widders
wonder103617813wonder_
wonders113315993wonders
yodler10389943yodler_
yodlers11298923yodlers
yonder103214133yonder_

Search took 9 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.1401276364.3
2DLD Change Limit1340272668.40615944.2
3Display Results2662660.1102418.2
 (SQL Overall)1786912668.65620643.6
 
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.