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

221 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
barflies133830(None) 
baffies153612942ba_ffies
baffles153710682baffl_es
bailies94120202ba_ilies
ballies93725742ba_llies
barbies114519592bar_bies
baronies10315022baronies
botflies1336732botflies
dayflies1534462dayflies
gadflies1334732gadflies
mayflies1644912mayflies
sawflies1444732sawflies
allies63827673_a_llies
applies11311213_applies
argles75218483_argl_es
arles56735743_ar_l_es
armies85123693_ar_mies
babbles104416323babbl_es
babies106123643ba__bies
backflips2243333backflips
baddies114017873ba_ddies
baffle14399873baffl_e_
baffled16418063baffl_ed
baffler15418113baffl_er
bafflers16356593bafflers
baffling1756053baffling
baggies113814853ba_ggies
bailees93914383ba_ilees
bailie83818363ba_ilie_
bairnlier1142233bairnlier
bairnliest1242623bairnliest
bakelites1545993bakelites
bakeries14312193bakeries
baldies105317703ba_ldies
bales76250083ba__l_es
balklines1536743balklines
banalizes201210093banalizes
bandies104124863ba_ndies
bangles103617413bangl_es
banshies131110663banshies
banties94324763ba_nties
barbes104526233bar__bes
barbie105018353bar_bie_
barbless12318713barbless
barbules1238043barbules
barbwires1643643barbwires
bardes95026933bar__des
bareges105212033bar_eges
bares75457133bar___es
barfed125416383barf__ed
barfing134615093barf_ing
barfly14339653barfl__y
barfs104826003barf___s
bargains1178643bargains
bargees105415873bar_gees
barges94528253bar__ges
barillas10310193barillas
barites94322333bar_ites
barkier133814483bar_kier
barkiest144115153bar_kiest
barkless14318023barkless
barless94317003bar_less
barley115116763bar_l_ey
barleys125011843bar_leys
barlows12259973bar_lows
barmaids1345933barmaids
barmie103816393bar_mie_
barmier114313043bar_mier
barmiest125212783bar_miest
barnier93213673bar_nier
barniest104815053bar_niest
barnlike1437183barnlike
baronnes1038553baronnes
baroques1934863baroques
barques18259643bar_ques
barrages11711083barrages
barres84427543bar__res
barrier94017733bar_rier
barriers104311883bar_riers
barrios9310773bar_rios
barwares13610093barwares
baryes116218503bar__yes
barytes124611153bar_ytes
basaltes10367683basaltes
baselines1138603baselines
basifies13310493basifies
bastiles10313353bastiles
battles94517683battl_es
baubles113611863baubl_es
bawdies134613393ba_wdies
bawdries14136843bawdries
bawties124214313ba_wties
belfries1336983belfries
belies84631053b__elies
bellies94023723b_ellies
berlines102315453ber_lines
berlins93216013ber_lins
berries94423553ber_ries
bialies93618413b_ialies
biffies152710853b_iffies
billies93923503b_illies
birdies104016213bir_dies
birdlimes1443093birdlimes
birkies133712433bir_kies
birles84920643bir_l_es
blackflies2143733blackflies
blowflies1742893blowflies
brailles1039483brailles
brandies11714563brandies
brassies103613533brassies
brawlie12198153brawlie_
brawlier13267043brawlier
brawliest14177193brawliest
braxies16711463b_raxies
bries74942153b_r__ies
brinies93317913b_rinies
brollies1039533brollies
brulyies1343423b_rulyies
brulzies1933983b_rulzies
bubblies1166773bubblies
bullies94121893b_ullies
burbles114916803burbl_es
burblier1255603burblier
burbliest1365583burbliest
burdies104117563bur_dies
burgles105615963burgl_es
buries84633273bur__ies
burlier93514413bur_lier
burliest103113053bur_liest
burnies94017823bur_nies
byrnies12378573byr_nies
carfares13310323carfares
caries85147623car__ies
carles85435083car_l_es
carlines103521643car_lines
carlins93921913car_lins
carnies94123963car_nies
carries94328013car_ries
charlies133414223char_lies
dailies84219263da_ilies
dallies84023193da_llies
darbies104216983dar_bies
darkies124015753dar_kies
darkles124011933darkl_es
darklier1335013darklier
darkliest1435163darkliest
dartles84014133dartl_es
deerflies1343913deerflies
earflaps1342553earflaps
earlier72612743ear_lier
earliest82415243ear_liest
families1339443families
farcies125317883far_cies
farles96025783far_l_es
ferlies103216693fer_lies
fireflies1545353fireflies
flies85630713___flies
gallflies1344223gallflies
gallies84122713ga_llies
garbles104016923garbl_es
gargles94214893gargl_es
garlics1038013gar_lics
girlies83013703gir_lies
halflives1842783halflives
hardies114923233har_dies
harelips1345213harelips
harpies123818313har_pies
harries103525493har_ries
hurlies103315333hur_lies
marbles114516653marbl_es
marblier1256343marblier
marbliest1336763marbliest
marlier92614773mar_lier
marliest102415183mar_liest
marlines103818713mar_lines
marlins93420473mar_lins
marlites103415263mar_lites
marries93825283mar_ries
medflies1435553medflies
nargiles976793nargiles
outflies11310143outflies
overflies1539103overflies
panfries13149203panfries
parfaits1346913parfaits
parflesh1643743parfl_esh
paries84742513par__ies
parities10522973parities
parles86334393par_l_es
parodies11313693parodies
parolees104313973parolees
paroles95025883parol_es
parries93925843par_ries
parslied1137803parslied
parties93230863par_ties
purfles122511843purfl_es
raffles133611843raffl_es
rallies73823343ra_llies
ramilies10311833ramilies
rarefies1138993rarefies
rarifies11311933rarifies
rarities8316333rarities
reflies104418533_reflies
relies65036423__relies
sallies73227813sa_llies
sandflies1346503sandflies
shadflies1643823shadflies
taffies133012693ta_ffies
tallies73624603ta_llies
tardies84225863tar_dies
tarries73324263tar_ries
varies94330873var__ies
waffies163611443wa_ffies
waffles16329983waffl_es
wafflier1733953wafflier
waffliest1844223waffliest
walies95324523wa__lies
wallies103320743wa_llies
warbles123215563warbl_es
warfares1436683warfares
warsles103413643warsl_es
yearlies1137603year_lies

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.1731032896.0
2DLD Change Limit1461622217.53019410.6
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.78322959.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.