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

244 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
barhops1428811(None) 
barhop13319641barhop_
carhops14329701carhops
barlows12259982barlows
barons85025382bar_ons
barrows123411692barrows
baryons121010472baryons
bathos116215632batho_s
bishops1437032bishops
carhop133610762carhop_
abhors11410623_abhors
abmhos1334973abmho_s
arbors84717883_arbors
archons12311583_archons
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argots74116033_argots
arhats9312983_arhats
armors85017813_armors
arrows92813493_arrows
arsons63917213_arsons
arvos86015673_arvo_s
babools11319453babools
baboons113211083baboons
baboos103517013ba_boos
baches135426943bach_es
backhoes1938543backhoes
backups1736173backups
bacons104917583ba_cons
baghouse1445213baghouse
bahts105617803ba_h_ts
bailors93212413bailors
bakeshops2042833bakeshops
balboas113710073balboas
ballons93916963ballons
ballots94116033ballots
bamboos1348753bamboos
bancos104713893banco_s
bandogs1138363bandogs
banjoes16317313banjoes
banjos15378893banjo_s
baps86040843ba___ps
barbels114514433barbels
barbers114317503barbers
barbes104526233bar_bes
barbets114915853barbets
barbies114519593barbies
barbs95928193bar__bs
barbuts11439843barbuts
barcas101016613bar_cas
barchans1588683barchans
bardes95026933bar_des
bards87139643bar__ds
bareges105212033bareges
bares75457133bar__es
barfs104826003bar__fs
bargees105415873bargees
barges94528253bar_ges
barhopped1942183barhopped
barites94322343barites
bariums1139153bariums
barkeeps1634143barkeeps
barkers134318513barkers
barks115735813bar__ks
barless94317003barless
barleys125011843barleys
barlow112911433barlo_w
barms96128473bar__ms
barneys12569563barneys
barns76335143bar__ns
baron78131243bar_o_n
barong96015823bar_ong
barongs105310833barongs
barony115915303bar_ony
barques18259643barques
barrels94514363barrels
barrens94414323barrens
barres84427553bar_res
barrets94917113barrets
barrios9310783barrios
barroom1139383barroom
barrooms1237903barrooms
barrow114512773barro_w
bars66564093bar___s
barters94223053barters
baryes116218503bar_yes
baryon111211613baryo_n
barytas12378283barytas
barytes124611153barytes
barytons1345573barytons
bashaws15347713bashaws
bashers124820833bashers
bashes115631393bash_es
basions94213953basions
bassos85313703basso_s
batboys1465833batboys
bathers124720363bathers
bathes116524833bath_es
bathoses13310463bathoses
baths105922923bath__s
batons85519423ba_tons
bayous11411153ba_yous
bazooms20285383bazooms
bazoos173212623ba_zoos
bearhugs1442533bearhugs
bebops1237633b_ebops
bellhops1544873bellhops
biros75325133bir_o_s
bishop1336943bishop_
bloops106611343b_loops
bohos105618253b_oho_s
boohoos1237993boohoos
bops86037983b___ops
borons85520543bor_ons
borrows12349263borrows
borzois1835833borzois
brahmas1436733brahmas
bravoes12418533bravoes
bravos114711403bravo_s
brios74725733b_rio_s
broods95416383b_roods
brooks125813883b_rooks
brooms104915873b_rooms
broos75126413b_r_oos
bros65635663b_r_o_s
brows105425983b_r_ows
burbots1168673burbots
burgoos1037123burgoos
burlaps1156253burlaps
burnous938823burnous
burps94220173bur__ps
burros85114993burro_s
burrows12399103burrows
burtons9310853burtons
cachous14312583cachous
cahows14399123ca_hows
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
cardons104519943cardons
cargoes104415223cargoes
cargos94619183cargo_s
carious93320283carious
carobs104818103car_obs
carols85124983car_ols
caroms105619573car_oms
carps96932253car__ps
carroms11512403carroms
carrots9714623carrots
cartons94122473cartons
cartop104213563cartop_
cashoos12310793cashoos
chops125019873__chops
crops96125243_cr_ops
droops95110963_droops
drops85719503_dr_ops
eardrops1165303eardrops
earlaps936393earlaps
earshots1146623earshots
faros85532023far_o_s
farrows13259793farrows
fathoms1537523fathoms
gallops103211653gallops
galops94712623ga_lops
garcons102411643garcons
garrons82713463garrons
harbors12412413harbors
hardtops1444843hardtops
harlots103413293harlots
harps105926873har__ps
harrows132611043harrows
hops97942633___hops
jalops15329593ja_lops
jargons1558203jargons
karoos102415813kar_oos
kaross101910023kar_oss
karroos1139313karroos
laptops1166603laptops
lardons83914493lardons
largos74815063largo_s
larrups934733larrups
lithops12307253lithops
machos135217493macho_s
mahoes11313103ma_hoes
markhors1745393markhors
markups1534963markups
marmots11311513marmots
maroons92615553maroons
marrons93216973marrons
marrows122911833marrows
maypops16104453maypops
nachos115014183nacho_s
narcos86714203narco_s
narrows10258853narrows
orlops847303_orlops
pardons103817623pardons
pareos87023773pareo_s
pargos95719043pargo_s
parlors9312923parlors
parlous9414293parlous
parols84722613par_ols
parous84024163par_ous
parrots9312743parrots
parsons93516873parsons
partons94620513partons
parvos116614753parvo_s
pathos115516693patho_s
perhaps1446123perhaps
preops104911953_preops
props95726893_pr_ops
ragtops1035453ragtops
rhos76319063__rho_s
saloops93510133saloops
sannops936693sannops
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sar_ods
saros55238063sar_o_s
sartors7314973sartors
scroops11288253scroops
shops104222903__shops
strops86220383str_ops
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarots66422993tar_ots
tarpons92612213tarpons
tarps76527123tar__ps
teashops1345733teashops
troops85712783_troops
various103113103various
varooms1248883varooms
wahoos122310593wa_hoos
wallops123410413wallops
warhorse1445353warhorse
warmups1433813warmups
warps107126423war__ps
warships1647553warships
warthogs1544833warthogs
washups1534683washups
whops135013933__whops
yahoos12209243ya_hoos
yarrows13277863yarrows

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272446.23321502.8
3Display Results2442440.0932623.7
 (SQL Overall)1786912446.73226543.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.