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

163 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
brandless123612(None) 
beardless1234912beardless
blandness1235972blandness
bondless1148812b_ondless
boundless1235182boundless
bractless1335542bractless
brainless1136402brainless
brakeless1544992brakeless
braless92910562bra__less
branchless1743302branchless
branders114313092brand_ers
brandies11714562brandie_s
breadless1235942breadless
brindles113710222brindle_s
brineless1136252brineless
broodless1235032broodless
glandless1134162glandless
grandness1138302grandness
handless123512062_handless
landless94011172_landless
rankless12268232_rankless
rindless92510192_rindless
sandless93212342_sandless
aidless83612073__aidless
backless162910633b_ackless
badness1039573b_a_dness
baldness1137043b_aldness
banders104324563b_and_ers
bandies104124863b_andie_s
bandiness122310243b_andiness
bangles103617413b_angle_s
barbless12318713b_arbless
barkless14318023b_arkless
barless94317003b_a_rless
baseless1099563b_aseless
bathless13127383b_athless
beadles103414733bea_dle_s
beakless14297383bea_kless
beamless12327003bea_mless
beatless103311593bea_tless
bedless1039703b__edless
bindles104016453b_indle_s
bladeless1234303bladeless
blameless1334733blameless
blandest113811043bland_est
blankness1544673blankness
blindness1235343blindness
blondness1234963blondness
bloodless1234513bloodless
boneless10310213b_oneless
boonless10328353boon_less
boundness1235943boundness
brabblers12335563brabblers
brabbles11349753brabble_s
bracelets1345963bracelets
bractlets1344753bractlets
braiders114110573braid_ers
braillers1135553braillers
brailles1039493braille_s
braininess1246123braininess
brambles14308973bramble_s
branches153613803branche_s
branchlets1743803branchlets
branded114414103brand_e_d
brander103915823brand_e_r
brandied1259113brandie_d
brandings13277483brandings
brandish1469023brand_ish
brandling1348253brandling
brandlings1443993brandlings
brands95118943brand___s
branners104010923bran_ners
branniest11199383branniest
brashness1436323brashness
brattles10199333brattle_s
braveness14237763braveness
brawlers13408643bra_wlers
brawniness1544033brawniness
breathless1543533breathless
bridlers11359183br_idlers
bridles104114473br_idle_s
briefless1443613briefless
brimless1235273br_imless
brindle104210103brindle__
brindled12407853brindle_d
brininess1138223brininess
broadness1256663broadness
browless1346653br_owless
brushless1444003brushless
budless1038873b__udless
bundlers11399183b_undlers
bundles103515773b_undle_s
candlers114214103_candlers
candles104422343_candle_s
chadless1436403cha_dless
chandlers15387673chandlers
cradlers11309203cra_dlers
cradles103114133cra_dle_s
crankles143510153crankle_s
dandlers103912053_dandlers
dandles94218533_dandle_s
endless839833__endless
fangless1237663_fangless
frameless1435533frameless
frankness1655223frankness
friendless1442543friendless
frontless1235403frontless
graceless12226893graceless
gradeless11236703gradeless
grainless1035893grainless
grandees103211283grand_ees
grandest10311573grand_est
granules939933granule_s
grassless1034303grassless
grateless10277583grateless
graveless13226693graveless
greedless1144893greedless
groundless1243473groundless
handlers124014143_handlers
handles114020653_handle_s
headless12289863hea_dless
kindless13289243_kindless
landlers94312833_landlers
leadless9248793lea_dless
maneless102812343_maneless
manless93012933_man_less
mindless11319443_mindless
paneless102611763_paneless
planless1036813plan_less
printless1137513printless
raddles93615703_raddle_s
rainless8129703_rainless
ranchless1444453_ranchless
randies84225663_randie_s
randiest93418773_randiest
randiness102511443_randiness
rankles113114543_rankle_s
rankness12267943_rankness
rayless10239003_ra_yless
roadless937703_roadless
rodless8310073_r_odless
rundles83214713_rundle_s
rundlets9307363_rundlets
rungless956733_rungless
runless72810423_run_less
soundless1035533soundless
spanless10247363span_less
tankless12267823_tankless
thankless1633203thankless
toadless936313toa_dless
traceless11228643traceless
trackless15246723trackless
trailless935963trailless
tramless1037503tra_mless
treadless1036003treadless
trindles93211683trindle_s
trundlers10215003trundlers
trundles9278483trundle_s
wardless12249303_wardless
windless123310863_windless
woundless1334033woundless
wranglers1344273wranglers
wrangles1237463wrangle_s

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411637.01621186.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.49923828.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.