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

137 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
brothels1327707(None) 
brothel12318191brothel_
brothers133410831brothers
bethels1238532b_ethels
botels84815802b_ot_els
bothers124317752b_others
brother123311332brothe_r
brotherly1743792brotherly
broths115013922broth__s
frothers14279812frothers
apothems1544223apothems
artels66216233ar_t_els
baratheas1444933baratheas
bathers124720363b_athers
bathes116524833b_athe_s
betels84515063b_et_els
bethel1169643b_ethel_
betrothals1552803betrothals
betrotheds1652503betrotheds
biofuels1342923biofuels
blathers134713793blathers
blethers13429613blethers
blithely16104033blithely
blithers134711233blithers
blotches1537433blotche_s
blotless10347153blotless
blotters104110983blotters
boatels93510233b_oatels
boches134618523b_oche_s
boheas114013213b_o_heas
bootees94114473boot_ees
booths115313793booth__s
booties94124613bootie_s
bootlegs11325873bootlegs
bootless103410983bootless
bordels103911973b_ordels
bortzes1838223bortze_s
boshes114721883b_oshe_s
botchers153511543b_otchers
botches143716023b_otche_s
botel75121863b_ot_el_
bother115218063b_othe_r
bothies12414783b_othies
bottles94216273b_ottles
bowels114315593b_o_wels
braches144621223brache_s
brachets154311983brachets
brashes124518463brashe_s
brattles10199333brattles
breathers14319103breathers
breathes134212903breathe_s
brioches15227253brioche_s
britches15278683britche_s
briths115113863brith__s
brittles10178653brittles
broachers16328153broachers
broaches153211623broache_s
broadens11267243broadens
brocatels1344193brocatels
broche133612103broche__
brockets16328123brockets
brogues10719823brogue_s
broiders114211193broiders
broilers103210093broilers
broils84114173bro__ils
brokers133111913bro_kers
bromals1139743bro_mals
bromes104719763bro_me_s
bronzers19296983bronzers
bronzes183510403bronze_s
brooches15288193brooche_s
brooders112610243brooders
broses86524403bro_se_s
broth106521093broth___
brothered1546003brothered
brothy14519623broth__y
browless1346653browless
browsers13449203browsers
browses124712693browse_s
brushers134210573brushers
brushes124014663brushe_s
brutely1235933brut_ely
brutes86118683brut_e_s
burthens1335383burthens
bushels124110713b_ushels
clothes124513813clothe_s
crochets15359833crochets
crotches153411303crotche_s
crotchets16396303crotchets
dottels8327783_dottels
druthers1275793druthers
frothed14288783frothe_d
frother133110153frothe_r
frothily1745303frothily
froths125411443froth__s
grovels11427813gro_vels
hotels94515523_hot_els
isohels1035393iso_hels
mohels115011333_mo_hels
motels83616903_mot_els
mothers123717623_mothers
northers1139333northers
others93918003__others
pothers123818623_pothers
pretzels1934033pretzels
propels113412843pro_pels
prophets1539503prophets
proteas92015123prot_eas
proteus92511593prot_eus
protheses1449073protheses
prothesis1449433prothesis
protyles13249833protyles
protyls12298463prot_yls
ratels64518213_rat_els
rochets124213473_rochets
rondels82510053_rondels
ronnels7318613_ronnels
rotches123515703_rotche_s
rotes56143903_rot_e_s
rotls55620163_rot__ls
rotters74421393_rotters
rottes64524833_rotte_s
rowels94515453_ro_wels
smothers13349933smothers
soothers113913433soothers
soothes103917113soothe_s
trochees132510183trochees
troches123715343troche_s
trochils1388583trochils
trommels12254333trommels
trothed114010973trothe_d
troths95414153troth__s
trotters83310243trotters
trotyls10236033trot_yls
trowels10358363tro_wels
writhers14398983writhers
writhes134811703writhe_s

Search took 7 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 Limit1461621376.46622604.7
3Display Results1371370.0502740.0
 (SQL Overall)1786911376.95225703.5
 
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.