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

280 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
reckless1425797(None) 
feckless17225781feckless
neckless14236431neckless
rockless14297291rockless
backless162910632backless
beakless14297382beakless
checkless2044232checkless
deckles143312802deckle_s
fleckless1842892fleckless
freckles17126382freckle_s
frockless1843452frockless
hecklers17357122hecklers
heckles163711382heckle_s
keckles12318762keckle_s
leakless12246982leakless
luckless14265892luckless
peakless14236682peakless
rankless12268242rankless
recess8314262rec__ess
recklessly1962922recklessly
reinless8139442reinless
restless82713162restless
riskless1235762riskless
ruckles133414602ruckle_s
sockless14267792sockless
suckless14288822suckless
tackless14419482tackless
trackless15246722trackless
wickless1736082wickless
barkless14318023barkless
beamless12327003beamless
beatless103311593beatless
beckets15399823beck_ets
bedless1039703be_dless
beefless1335493beefless
beltless10297713beltless
benchless1644153benchless
bractless1335543bractless
breadless1235943breadless
brickles162810283brickle_s
bucklers16349503bucklers
buckles153416093buckle_s
cacklers163710703cacklers
cackles153717203cackle_s
cheekless1873883cheekless
clickless1743983clickless
cockles153414643cockle_s
cookless14258633cookless
crackles164111273crackle_s
crestless1146783crestless
crewless1335413cre_wless
debtless1135653debtless
decayless1542863decayless
deciles104417723decile_s
deckels14367363deck_els
deckers144413833deck_ers
deckle1312012453deckle__
declass1038733dec_lass
deedless10318253deedless
dewless1137473de_wless
dreamless1243513dreamless
ductless11196313ductless
earless74316073_earless
echoless1345603_echoless
eggless935663_eggless
egoless836983_egoless
endless839833_endless
erectness1146123erectness
eyeless1058053_eyeless
faceless13269173faceless
fearless1137873fearless
fecklessly2282653fecklessly
feeless103511103fe_eless
feetless1137383feetless
fenceless1444163fenceless
fernless1136063fernless
ficklest17267903ficklest
flockless1843163flockless
forkless15267433forkless
freckle16106643freckle__
freckled18104443freckle_d
freckliest1943383freckliest
fretless1138063fre_tless
gearless937373gearless
geckoes14325793geckoe_s
graceless12226893graceless
grackles15309183grackle_s
greedless1144893greedless
hacklers173710303hacklers
hackles162917063hackle_s
headless12289863headless
heatless113011463heatless
heckle153112093heckle__
heckled17318463heckle_d
heckler16278573heckle_r
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
hookless151238363hookless
huckles163612623huckle_s
iceless9219963_iceless
inkless11348713_inkless
ireless72312243ire__less
jacklegs2233963jacklegs
keckle11359423keckle__
keckled13376503keckle_d
keelless12236193keelless
keyless1436163ke_yless
knockless1442443knockless
laceless10239853laceless
leadless9248793leadless
leafless11246573leafless
legless838013le_gless
lensless835583lensless
mackles154415753mackle_s
mealless10288363mealless
meatless103410863meatless
meekness1434303meekness
merciless1344473merciless
mickles153415003mickle_s
micklest16219123micklest
milkless1434773milkless
muckles153413253muckle_s
neckers134210463neck_ers
needless9308333needless
netless739863ne_tless
newsless1134533newsless
nickles133713823nickle_s
packness1636933packness
peckers153312673peck_ers
peckiest162711393peckiest
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
pickles153215443pickle_s
prebless1236823pre_bless
precess11310863prec__ess
priceless1336893priceless
prickles162511103prickle_s
raciness102413453raciness
rackers134320453rack_ers
rackets134916873rack_ets
rackle123917293rackle__
rainless8129713rainless
ranchless1444453ranchless
rankles113114553rankle_s
rankness12267943rankness
rayless10239003r_ayless
reales64934123re_ale_s
realest73322433re_alest
realness8410443realness
reassess836513reassess
recallers1137103recallers
recalls92613623recal_ls
recanes93222263recane_s
recces10614913rec_ce_s
recedes102816063recede_s
recesses10312323recesses
rechews1537293rec_hews
recipes113314463recipe_s
reciters102613113reciters
recites93524583recite_s
recked134821803reck_e_d
reckoners1545113reckoners
reckons13269653reck_ons
recks115625133reck___s
reclads1049993rec_lads
reclasp1136643rec_lasp
reclasps1235053rec_lasps
reclean938523rec_lean
recleans1037513rec_leans
recluse95210773rec_luse
recluses105111733rec_luses
recodes102918633recode_s
recoilers11318153recoilers
recoilless1242713recoilless
recolors1078813recolors
recovers133511123recovers
recross989843rec_ross
recuses94619463recuse_s
recyclers1642973recyclers
recycles1535353recycle_s
reddles93315773reddle_s
redlegs936823re_dlegs
redness82012443re_dness
redress82511873re_dress
reekers113613143reek_ers
reekiest122711313reekiest
reelers73520273re_elers
refiles104122423refile_s
reflets103513153re_flets
regalers94311133regalers
regales83520793regale_s
regalness1045473regalness
reglets83512983re_glets
regloss8218023re_gloss
regress82711453re_gress
rekeys13347693re_k_eys
relets64025673re__lets
repress92712683re_press
repulses1038393repulses
resales74724903resale_s
rescales103414573rescale_s
resiles74026543resile_s
resoles73823653resole_s
restress82511773restress
retackles1545363retackle_s
retiles74426993retile_s
revelers113414133revelers
revilers114011693revilers
reviles104421353revile_s
ribless93410343r_ibless
richness1337433richness
rickets134915093rick_ets
rickeys16548983rick_eys
riftless1136943riftless
rimless9369363r_imless
rindless92510203rindless
roadless937703roadless
rockers133916553rock_ers
rockets134615363rock_ets
rockiest142912223rockiest
rockiness15237833rockiness
rodless8310073r_odless
roofless11316733roofless
rootless83910443rootless
ruckle124414583ruckle__
ruckled144111033ruckle_d
ruckuses1444913ruckuses
ruleless836633ruleless
rumpless12256543rumpless
rungless956733rungless
runkles114111943runkle_s
runless72810423r_unless
rustless83510243rustless
ruthless1135413ruthless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243se_xless
sickles133417543sickle_s
sickness1437833sickness
speckles16268133speckle_s
stackless1555933stackless
sucklers14379963sucklers
suckles134516743suckle_s
tacklers143010773tacklers
tackles133816523tackle_s
tactless10288463tactless
tankless12267823tankless
tearless848713tearless
tentless8229843tentless
termless1036233termless
textless15245793textless
ticklers14339303ticklers
tickles133416853tickle_s
traceless11228643traceless
treadless1036003treadless
treeless839283tre_eless
trickles143013763trickle_s
truceless11235393truceless
trucklers15295583trucklers
truckles14319383truckle_s
tuskless1234213tuskless
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
viceless1337983viceless
weakness1535353weakness
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
workless15276803workless
wreckers17315973wreck_ers
zestless17247433zestless

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622807.20320291.8
3Display Results2802800.1102545.5
 (SQL Overall)1786912807.73623098.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.