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

146 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
bractless133554(None) 
bractlets1344751bractlets
backless162910632b_ackless
beatless103311592bea_tless
bracelets1345962bracelets
bractlet1239282bractle_t
brainless1136402brainless
brakeless1544992brakeless
braless92910562bra__less
branchless1743302branchless
brandless1236122brandless
brattles10199332brattle_s
graceless12226892graceless
tactless10288462_tactless
traceless11228642traceless
trackless15246722trackless
actress948533__actress
artless73712513__artless
barbless12318713b_arbless
barkless14318023b_arkless
barless94317003b_a_rless
baseless1099563b_aseless
bathless13127383b_athless
battlers104110973b_attlers
battles94517683b_attle_s
beakless14297383bea_kless
beamless12327003bea_mless
beardless1234913beardless
beltless10297713b_eltless
benchless1644153benchless
blacklegs1843913blacklegs
blackness1735663blackness
bladeless1234303bladeless
blameless1334733blameless
blotless10347153b_lotless
boltless10338283b_oltless
bootless103410983b_ootless
brabblers12335563brabblers
brabbles11349753brabble_s
bracelet12310693bracele_t
bracers114616703brac__ers
braces108427773brac__e_s
braches144621223brac_he_s
brachets154311983brac_hets
bracioles1346493braciole_s
brackens16327923brac_kens
brackets163310433brac_kets
bracteal1245563bract_eal
bracted12410933bract_e_d
bracteoles1443413bracteole_s
bracts105617773bract___s
braillers1135553braillers
brailles1039493braille_s
brambles14308973bramble_s
branchlets1743803branchlets
brashness1436323brashness
brattiest1148103brattiest
brattiness1255843brattiness
brattle9249253brattle__
brattled11196723brattle_d
braveness14237763braveness
brawlers13408643bra_wlers
breadless1235943breadless
breathless1543533breathless
brickles162810283brickle_s
bricoles122610303bricole_s
briefless1443613briefless
brimless1235273br_imless
brineless1136243brineless
bristles101510433bristle_s
brittles10178653brittle_s
brittlest11146193brittlest
broodless1235033broodless
browless1346653br_owless
brushless1444003brushless
chartless1435703chartless
coatless1039693coa_tless
crackles164111273crackle_s
crestless1146783crestless
crustless1155403crustless
ductless11196313_ductless
erectness1146123erectness
exactness1843623exactness
faceless13269173_faceless
fatless103212203_fa_tless
feastless1235043feastless
frameless1435533frameless
fretless1138063fr_etless
frockless1843453frockless
frontless1235403frontless
frostless1235743frostless
fruitless1244163fruitless
graciles112511613gracile_s
grackles15309183grackle_s
gradeless11236703gradeless
grainless1035893grainless
grassless1034303grassless
grateless10277583grateless
graveless13226693graveless
haltless11308443_haltless
hatless103813443_ha_tless
heartless1236393heartless
heatless113011463hea_tless
laceless10239853_laceless
mastless102610023_mastless
matless93014043_ma_tless
meatless103410863mea_tless
objectless2151683objectless
oracles93212423orac_le_s
oratress834553ora_tress
pastless102411203_pastless
placeless1335613placeless
practises1349623practises
prattlers11195323prattlers
prattles10189403prattle_s
priceless1336883priceless
printless1137513printless
raciness102413453_raciness
rainless8129703_rainless
ranchless1444453_ranchless
rankless12268233_rankless
raptness1046733_raptness
rattlers83510293_rattlers
rattles73217303_rattle_s
rayless10239003_ra_yless
reckless14257973_reckless
restless82713163_restless
riftless1136943_riftless
rockless14297293_rockless
rootless83910443_rootless
rustless83510243_rustless
saltless8259343_saltless
seatless83213003sea_tless
spaceless1335733spaceless
stackless1555933stackless
tackless14419483_tackless
trachles13311753trachle_s
trailless935963trailless
traitress944403traitress
tramless1037503tra_mless
truceless11235393truceless
trustless955953trustless
wartless11279923_wartless
wattless11268723_wattless
wrastles11328933wrastle_s
yeastless1234053yeastless

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 Filter1786911486410.410435831.7
2DLD Change Limit1486411467.59319576.1
3Display Results1461460.0602433.3
 (SQL Overall)1786911468.06322161.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.