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

141 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
burthens133538(None) 
burthen1236361burthen_
burdens1039712bur_dens
burghers1435632burghers
burthened1543962burthened
burtons9310852burt_ons
furthers1436492furthers
murthers1336542murthers
baratheas1444923baratheas
barchans1588683barchans
barrens94414323bar_rens
bartend1038753bart_end
bartends1136793bart_ends
barters94223033bart_ers
bathers124720363b_athers
bathes116524833b_athe_s
battens95313263b_attens
benthons1337973benthons
berthas12398763berth_as
berthed13259123berthe_d
berthing14209593berthing
berths114712423berth__s
bethels1238533b_ethels
birchen14347883birchen_
birches143412323birche_s
birthed13228593birthe_d
birthing14338433birthing
birthings15254623birthings
births115713603birth__s
blathers134713793blathers
blethers13429613blethers
blithers134711233blithers
blurters10348373blurt_ers
boreens9310403bor_eens
bortzes1838223bortze_s
bothers124317753b_others
bourtrees11154013bourtrees
brazens18418713b_razens
brens75823363b_r__ens
brothels13277073brothels
brothers133410833brothers
brushers134210573brushers
brushes124014663brushe_s
brutes86118683brut_e_s
buckeens1634853buckeens
bullpens1254083bullpens
bunches144116033bunche_s
bunters94717123bunt_ers
burans85019303bur__ans
burblers12399263burblers
burbles114916803burble_s
burden9412473bur_den_
burdies104117563burdie_s
burets84321263bur__ets
burettes1048953burette_s
burgees104915893bur_gees
burgeons1146053burgeons
burgers103918573bur_gers
burgess10409343bur_gess
burgher1337003burghe_r
burghs12519923burgh__s
burgles105615963burgle_s
buriers94017193bur_iers
buries84633273bur_ie_s
burins84221893bur__ins
burkers133716623bur_kers
burkes124421313bur_ke_s
burlers94120273bur_lers
burleys12479673bur_leys
burners94115673bur_ners
burnets93813263bur_nets
burnies94017823burnie_s
burns74926783bur___ns
burrers93814493bur_rers
burseeds1134783burseeds
burses84425513bur_se_s
bursters1038983bursters
burstones1187153burstones
burthening1643463burthening
burton8311273burt_on_
burweeds1434103burweeds
bushels124110713bu_shels
bushers124018803bu_shers
bushes115226113bu_she_s
busters94724133bust_ers
bustiers103810053bustiers
bustlers104210613bustlers
bustles93816323bustle_s
butanes9312743bu_tanes
butchers153710183butchers
butches144315363butche_s
butene8312623bu_t_ene
butenes9313033bu_t_enes
buteos84913413bu_t_eos
butes714535873bu_t_e_s
butlers94518053bu_tlers
butles84423913bu_tle_s
butters94521723bu_tters
buttes84822563bu_tte_s
butthead1454513butthead
buttheads1553903buttheads
butties93217953buttie_s
buttons9310333bu_ttons
buttress1035883buttress
curches143512743curche_s
curtains10259703curtains
curtness1037263curtness
curtseys1342743curtseys
druthers1275793druthers
duramens1195153duramens
earthen1039253earthen_
fourteens1243343fourteens
further1337003furthe_r
furthest1496863furthest
gorhens1137183gor_hens
gurshes112210033gurshe_s
harshens1437603harshens
heathens143210153heathens
hurters103413643hurt_ers
hurtles103913753hurtle_s
hurtless11307783hurtless
kuchens1634713ku_chens
lurchers13307153lurchers
lurches123311663lurche_s
lutherns1136293lu_therns
martens93714953mart_ens
mudhens1335103mu_dhens
murther1237953murthe_r
northerns1244933northerns
northers1139333northers
qurshes19228573qurshe_s
sithens1039383_sithens
subteens1037423subteens
thens85921833___thens
tureens7289873tur_eens
turtlers8258203turtlers
turtles72914343turtle_s
urchins1238863_urchins
urethans1145243_urethans
wuthers133711523wu_thers
youthens1435383youthens

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621417.89318517.9
3Display Results1411410.0632238.1
 (SQL Overall)1786911418.39221293.0
 
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.