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

260 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
brollies103953(None) 
trollies8310231trollies
ballies93725742b_allies
bellies94023722b_ellies
billies93923502b_illies
bollixes1747202b_ollixes
brookies1459142brookies
brownies13189612brownies
brulyies1343422brulyies
brulzies1933982brulzies
bullies94121892b_ullies
collies94326582_collies
dollies83620982_dollies
follies103618942_follies
hollies103420812_hollies
jollies143516272_jollies
lollies73116922_lollies
mollies93420232_mollies
rallies73823342_rallies
trollied935892trollied
woollies1147412woollies
allies63827673__allies
bailies94120203b_ailies
baldies105317703b_aldies
barflies1338303barflies
baronies10315023baro_nies
belies84631053b__elies
belles85325993b_ell_es
bellied104314073b_ellied
bialies93618413b_ialies
bilbies114712333b_ilbies
billie85019173b_illie_
biologies12311183biologies
biolyses1345573biolyses
biopsies1237383biopsies
bloodies11310163bloodies
blowflies1742893blowflies
bobbies103714563b_obbies
boccies133311513b_occies
bodies94524143b_o_dies
bogies94724313b_o_gies
bogles95020833b_ogl_es
bolases93315003b_olases
boles75448603b_o_l_es
boletes9316063b_oletes
bolides10515073b_olides
bolled94722653b_oll_ed
bolling103820883b_olling
bollix1538053b_olli_x
bollixed1834483b_ollixed
bolloxes1736833b_olloxes
bolls75531313b_oll__s
bolshies1338693b_olshies
boluses94113833b_oluses
boobies113718203b_oobies
boodies103721443b_oodies
boodles103416043boodl_es
boogies103719013b_oogies
bookies133819403b_ookies
boonies93422483b_oonies
booties94124613b_ooties
bossies94116833b_ossies
botflies1336733botflies
bothies12414783b_othies
bougies103715183b_ougies
boules84925973b_oul_es
boulles93114123b_oulles
bowlines133211623b_owlines
brailles1039483brailles
brandies11714563brandies
brassies103613533brassies
brawlie12198153brawlie_
brawlier13267043brawlier
brawliest14177193brawliest
braxies16711463br_axies
bridles104114473bridl_es
bries74942153br___ies
brillos9369173brill_os
brills84916293brill__s
brinies93317913br_inies
brionies10310543brionies
broaches153211623broaches
brocades1358703brocades
brocolis1247303brocoli_s
brogues10719823bro_gues
broiled103811423broil_ed
broiler92911753broil_er
broilers103210093broilers
broiling113112013broiling
broils84114173bro__ils
brokages1536253brokages
brolly114510853broll__y
bromates12413133bromates
bromelins1346453bromelins
bromes104719763bro__mes
bromides13219363bromides
bromids12278603bro_mids
bromines122514253bromines
bromins112513783bro_mins
bromizes21258333bromizes
bronzes183510403bro_nzes
bronzier1935633bronzier
bronziest2035813bronziest
brooches15288193brooches
broodier1157433broodier
broodiest1237823broodiest
brookie1347373brookie_
brookites1545033brookites
brooklimes1841903brooklimes
broomier1236873broomier
broomiest1356913broomiest
broses86524403bro__ses
browallias1552113browallias
browless1346653browless
brownie12178433brownie_
brownier13226913brownier
browniest14207123browniest
browses124712693bro_wses
brulyie1242523brulyie_
brulzie1842883brulzie_
brumbies1436533brumbies
bryologies1646043bryologies
bryonies1336843bryonies
bubblies1166773bubblies
bullied104514813b_ullied
bullier94116433b_ullier
bulliest104314493b_ulliest
challies133915633challies
chillies134113473chillies
colies84837053_co_lies
collides113214463_collides
collie83621993_collie_
collied103316673_collied
collier93618153_collier
colliers103613583_colliers
collins93419833_collins
coolies93824963_coolies
cronies9622503cro_nies
croppies143111133croppies
crowdies1437543crowdies
cullies94419963_cullies
dallies84023193_dallies
dellies83622213_dellies
dhoolies1246963dhoolies
dillies84122153_dillies
doilies84017363_doilies
dollied93811143_dollied
doolies83920713_doolies
doylies114512573_doylies
drolled93810223droll_ed
droller84110283droll_er
drolleries1145443drolleries
drollest937353droll_est
drolling103510763drolling
drollness1043623drollness
drolls75312393droll__s
droolier936073droolier
drooliest1036343drooliest
dropsies1138693dropsies
droskies13186343droskies
enrollees974323enrollees
fellies104119743_fellies
fillies103420253_fillies
folkies143612253_folkies
folles93820473_foll_es
follis93113903_folli_s
frillier1136513frillier
frilliest1237113frilliest
frolics1236833fro_lics
gallies84122713_gallies
ghillies12408663ghillies
ghoulies1235393ghoulies
gillies84120963_gillies
girolles935523giroll_es
goalies8316023_goalies
googlies1086763googlies
grilles83715023grill_es
groupies1137523groupies
growlier1234883growlier
growliest1335583growliest
gullies84717313_gullies
holies94630033_ho_lies
holloes103818193_holloes
ironies7517423iro_nies
jellies143816533_jellies
jollied15349273_jollied
jollier142911003_jollier
jolliers15357433_jolliers
jolliest152910363_jolliest
kellies113516853_kellies
killies113318113_killies
loblollies1251393loblollies
molies84429513_mo_lies
mollie83517103_mollie_
nellies73418723_nellies
oldies7314423__oldies
orologies10311623orologies
polies84034583_po_lies
pollees93215333_pollees
pollices12410753_pollices
proclises1339543proclises
profiles133211233profiles
proles84627203pro_l_es
prolines102619693prolines
prossies101515223prossies
prosties101421193prosties
proxies163014933pro_xies
rallied83514083_rallied
rallier73816273_rallier
ralliers84010833_ralliers
rallyes10348553_rallyes
reflies104418533_reflies
relies65036423_r_elies
replies94521043_replies
rilles64725503_rill_es
roadies83317433_roadies
robles85321693_robl_es
roilier7311523_roilier
roiliest8312283_roiliest
roles56747983_ro_l_es
rolled74220243_roll_ed
roller63919793_roll_er
rollers73117473_rollers
rollick1335613_rollick
rollicks1444893_rollicks
rolling83620413_rolling
rollings9419953_rollings
rolls55326233_roll__s
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
rowdies113112693_rowdies
sallies73227813_sallies
sillies73425073_sillies
stoolies8311083stoolies
sullies74122223_sullies
tallies73624603_tallies
tellies73820503_tellies
trellis739873trelli_s
trellises947023trellises
trilbies1037693trilbies
troilites948433troilites
trolled84312263troll_ed
troller73913173troll_er
trollers83211203trollers
trolley10328753troll_ey
trolleys11315693trolleys
trolling93212493trolling
trollings10286693trollings
trollops1044803trollops
trolls64613943troll__s
trophies13413673trophies
trotlines939103trotlines
urologies1039533urologies
wallies103320743_wallies
wellies103719073_wellies
willies103920153_willies
woolies104117363_woolies
woollier1155433woollier
woolliest1235853woolliest

Search took 8 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.1561145455.1
2DLD Change Limit1461622607.62619166.3
3Display Results2602600.1062452.8
 (SQL Overall)1786912607.88822653.5
 
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.