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

132 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
breadless123594(None) 
treadless1036001treadless
beadles103414732b_eadle_s
beakless14297382b_eakless
beamless12327002b_eamless
beardless1234912b_eardless
beatless103311592b_eatless
bedless1039702b_e_dless
braless92910562br_a_less
brandless1236122brandless
breathless1543532breathless
broadness1256662broadness
broodless1235032broodless
dreamless1243512dreamless
greedless1144892greedless
headless12289862_headless
leadless9248792_leadless
roadless937702_roadless
threadless1442472threadless
treadlers1045892treadlers
treadles939702treadle_s
badness1039573b__adness
barless94317003b__arless
beaders104120183b_ead_ers
beadiest113815533b_eadiest
beadiness12249233b_eadiness
beadle93314683b_eadle__
beagles103212123b_eagle_s
beefless1335493b_eefless
beltless10297713b_eltless
berryless1442293berryless
bladeless1234303b_ladeless
bleakness1543593bleakness
bloodless1234513bloodless
bondless1148813b_ondless
boundless1235183boundless
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
brawlers13408643br_awlers
breachers16369853breachers
breaches153714123breache_s
breaded115014063bread_e_d
breadline1246273breadline
breadlines1345733breadlines
breadnuts1243143breadnuts
breads95419203bread___s
breadths1474463bread_ths
breakers143810973brea_kers
breathers14319103breathers
breathes134212903breathe_s
bredes94818473bre_d_e_s
breeders11368893breed_ers
breezeless2141693breezeless
bridlers11359183br_idlers
bridles104114473br_idle_s
briefless1443613briefless
brimless1235273br_imless
brindles113710223brindle_s
brineless1136253brineless
broadens11267243broad_ens
broadest1138573broad_est
broadleaf1542603broadleaf
browless1346653br_owless
brushless1444003brushless
budless1038873b__udless
chadless1436403_chadless
cradlers11309203cr_adlers
cradles103114133cr_adle_s
creaseless1243643creaseless
crestless1146783crestless
crewless1335413cre_wless
deadness1039233_deadness
deedless10318253_deedless
earless74316073__earless
endless839833__endless
fearless1137873_fearless
fretless1138063fre_tless
friendless1442543friendless
gearless937373_gearless
gradeless11236703gr_adeless
greaseless1143483greaseless
greatness1036903greatness
heatless113011463_heatless
heedless12278813_heedless
idealess935653idea_less
idealless1042953idealless
ireless72312243ire__less
leafless11246573_leafless
leakless12246983_leakless
mealless10288363_mealless
meatless103410863_meatless
needless9308333_needless
peakless14236683_peakless
pleatless1134613pleatless
prebless1236823pre_bless
rayless10239003_r_ayless
readdress1143823_readdress
readers83823773_read_ers
readies83324713_readie_s
readiest93719043_readiest
readiness102611853_readiness
reales64934123_rea_le_s
realest73322433_rea_lest
realness8410443_realness
reassess836513_reassess
reckless14257973_reckless
reddles93315773_reddle_s
redlegs936823_re_dlegs
redness82012443_re_dness
redress82511873_re_dress
regardless1252893_regardless
reinless8139433_reinless
restless82713163_restless
rindless92510193_rindless
rodless8310073_r_odless
seamless10238723_seamless
seatless83213003_seatless
seedless9319513_seedless
tearless848713_tearless
toadless936313_toadless
tramless1037503tr_amless
treacles1039703treacle_s
treaders93311843tread_ers
treadle8310103treadle__
treadled1067123treadle_d
treadler936863treadle_r
treddles1036263treddle_s
treeless839283tre_eless
weedless12287963_weedless
weldless12285813_weldless
wheatless1534003wheatless

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.703254183.5
2DLD Change Limit1486411327.64019455.6
3Display Results1321320.0462869.6
 (SQL Overall)1786911328.38921300.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.