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

208 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
brothel1231819(None) 
brothels13277071brothels
brother123311331brother
bethel1169642b_ethel
botel75121862b_ot_el
bother115218062b_other
broche133612102broche_
broth106521092broth__
brotherly1743792brotherly
brothers133410822brothers
broths115013922broth_s
brothy14519622broth_y
frothed14288782frothed
frother133110152frother
trothed114010972trothed
another10289153another
apothem1444633apothem
artel56122743ar_t_el
barathea1345273barathea
bathe105822883b_athe_
bathed125518743b_athed
bather115322513b_ather
bathes116524833b_athes
benthal1247953benthal
berthed13259123berthed
betel74419903b_et_el
bethels1238533b_ethels
betrothal1453473betrothal
betrothed1544943betrothed
biofuel1243293biofuel
birthed13228593birthed
blather125314203blather
blether12459913blether
blithe115810863blithe_
blithely16104033blithely
blither124812173blither
blotched1635653blotched
blotches1537433blotches
blotted103911833blotted
blotter94612853blotter
boatel84314093b_oatel
boche124216953b_oche_
boches134618523b_oches
bohea105013733b_o_hea
booted94822733boot_ed
bootee84323023boot_ee
bootees94114473bootees
booth105522013booth__
booths115313793booth_s
bootie85421153bootie_
booties94124613booties
bootleg10276633bootleg
bordel94514573b_ordel
bortzes1838223bortzes
boshes114721883b_oshes
botched153611903b_otched
botcher143613223b_otcher
botches143716023b_otches
botels84815803b_ot_els
both96533433b_oth__
bothers124317753b_others
bothies12414783b_othies
bothy136713963b_oth_y
bottle84916073b_ottle
bowel105621203b_o_wel
braches144621223braches
brachet144020313brachet
brasher124515233brasher
brashes124518463brashes
brattle9249253brattle
breathe123711843breathe_
breathed14469643breathed
breather133610593breather
breathes134212903breathes
brethren1343783brethren
brioche14275923brioche_
brioches15227253brioches
britches15278683britches
brith104924373brith__
briths115113863brith_s
brittle9168603brittle
broached16309123broached
broacher15329263broacher
broaches153211623broaches
broaden10289143broaden
broader103412603broader
brocatel1246713brocatel
brocket154013383brocket
brogue94211033brogue_
brogues10719823brogues
broider103912973broider
broil74918223bro__il
broiled103811423broiled
broiler92911753broiler
broke116019783bro_ke_
broken124011523bro_ken
broker124314243bro_ker
bromal10313653bro_mal
brome94421973bro_me_
bromes104719763bro_mes
bronze173610923bronze_
bronzed19308213bronzed
bronzer18348493bronzer
bronzes183510403bronzes
brooches15288193brooches
brooded113510933brooded
brooder103811623brooder
brooked143610033brooked
broomed124111053broomed
brose75227033bro_se_
broses86524403bro_ses
brothered1546003brothered
browed125216393bro_wed
browned134710973browned
browner124911643browner
browse115713853browse_
browsed134511233browsed
browser124911143browser
browses124712693browses
brushed133811213brushed
brusher123813003brusher
brushes124014663brushes
brutal859383brut_al
brute75321783brut_e_
bruted95113263brut_ed
brutely1235933brut_ely
brutes86118683brut_es
burthen1236363burthen
bushel114513943b_ushel
clothe114712993clothe_
clothed134010283clothed
clothes124513813clothes
crochet143616663crochet
crotched16428593crotched
crotches153411293crotches
crotchet152711993crotchet
dottel73610893_dottel
froth115919283froth__
frothers14279803frothers
frothier1435953frothier
frothily1745303frothily
froths125411443froth_s
frothy15578373froth_y
grovel104310543gro_vel
hotel85520743_hot_el
isohel935483iso_hel
mohel104914833_mo_hel
motel76623243_mot_el
mother113718643_mother
norther1039733norther
nother93815963_nother
other84219103__other
pother113818853_pother
pretzel1835143pretzel
prithee1239933prithee
propel103714063pro_pel
prophet14316033prophet
protea82214763prot_ea
protei82615303prot_ei
protyl11308213prot_yl
protyle12229453protyle
prythee1545383prythee
ratel54224883_rat_el
rathe85821923_rathe_
rather94319733_rather
rochet115423003_rochet
rondel73212643_rondel
ronnel63310883_ronnel
rotche114311983_rotche_
rotches123515703_rotches
rote46249023_rot_e_
rotes56143903_rot_es
rotl45029683_rot__l
rotte54625933_rotte_
rotted74524433_rotted
rotten64115433_rotten
rotter64325463_rotter
rottes64524833_rottes
rowel84721413_ro_wel
smother123510203smother
soothe94214843soothe_
soothed113712733soothed
soother104215033soother
soothes103917103soothes
toothed113310243toothed
tother94117143_tother
trochal1288243trochal
troche113112513troche_
trochee122613873trochee
troches123715343troches
trochil1258703trochil
trommel11315363trommel
troth85622203troth__
troths95414153troth_s
trotted83711283trotted
trotter73312253trotter
trotyl9236673trot_yl
trowel94211463tro_wel
worthed1437873worthed
wrathed14298523wrathed
writhe125310703writhe_
writhed14389623writhed
writhen13407863writhen
writher134010853writher
writhes134811703writhes
wrote84717483wrot_e_
wroth116815883wroth__
wrothful1742813wrothful

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272087.94016880.0
3Display Results2082080.1531359.5
 (SQL Overall)1786912088.24921662.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.