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

373 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
carboys14471178(None) 
carbons115418941carbons
carbos105122261carbo_s
carboy134914181carboy_
arbors84717882_arbors
batboys1465832batboys
cabobs124311892ca_bobs
callboys1585182callboys
carbo94923842carbo__
carbon104919042carbo_n
carbonyl1595382carbonyl
carbonyls1675032carbonyls
carbora11310702carbora
carboras12311582carboras
carboxyl22103632carboxyl
carboxyls2363692carboxyls
carboyed1637182carboyed
carbs96031462carb__s
cardons104519932cardons
cargoes104415222cargoes
cargos94619182cargo_s
carhops14329702carhops
caribous1258822caribous
carious93320282carious
carneys124310542carneys
carobs104818102car_obs
carols85124982car_ols
caroms105619572car_oms
carroms11512402carroms
carrots9714622carrots
cartons94122472cartons
charpoys1834532charpoys
cowboys1735252cowboys
harbors12412412harbors
abbeys13538423_abbeys
abbots1039283_abbots
abos67734413_a_bo_s
abys97221883_a_b_ys
acarbose1244683acarbose
acarboses1345083acarboses
acarpous1245313acarpous
across8312643acr_oss
alloys94014563_alloys
ambos95321253_ambo_s
annoys967523_annoys
arbor74818113_arbo_r
arbores94016033_arbores
arbour84211333_arbour
arbours93910043_arbours
arbs66834733_arb__s
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argosy1036423_argosy
argots74116033_argots
armors85017813_armors
arrays95311683_arrays
arrows92813483_arrows
arroyo936963_arroyo
arroyos1036533_arroyos
arsons63917213_arsons
arvos86015663_arvo_s
baboos103517013ba_boos
balboas113710073balboas
bamboos1348753bamboos
barbels114514433barbels
barbers114317503barbers
barbes104526233barb_es
barbets114915843barbets
barbies114519593barbies
barbs95928193barb__s
barbuts11439843barbuts
barhops14288113barhops
barleys125011843barleys
barlows12259973barlows
barneys12569563barneys
barons85025383bar_ons
barrows123411683barrows
baryons121010473baryons
batboy1387533batboy_
boys96737333___boys
burbots1168673burbots
busboys14325023busboys
cabals104020153ca_bals
cabbies133115163cabbies
cabby145314563ca_bby_
cabers105023923ca_bers
cabins104418923ca_bins
cables104527553ca_bles
cabob114616813ca_bo_b
caboose1138273ca_boose
cabs86739423ca_b__s
cacaos104616183cacao_s
cachous14312583cachous
cahoots1238473cahoots
cahows14399123ca_hows
callboy1465833callboy_
callous93516603callous
calos74431903ca_lo_s
cambers134017443cambers
cameos105818003cameo_s
camions113916133camions
camos95927613ca_mo_s
campos125217953campo_s
candors104216763candors
cannons94412883cannons
canoes84725883ca_noes
canons85522063ca_nons
cansos84915383canso_s
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
capons104119503ca_pons
capos94826073ca_po_s
captors113914983captors
carabaos1238073carabaos
carabids1338193carabids
carabins12312353carabins
caracks152211563caracks
caracols12310413caracols
carafes125015703carafes
carates95630613carates
carats85929023car_ats
caraways1636943caraways
carb85143163carb___
carbamoyl1851893carbamoyl
carbamoyls1951793carbamoyls
carbamyl1743103carbamyl
carbamyls1843033carbamyls
carbarn1139453carbarn
carbarns1238563carbarns
carbaryl1544423carbaryl
carbaryls1644013carbaryls
carbide126112493carbide
carbides133111693carbides
carbine112918643carbine
carbines123617533carbines
carbinols1346113carbinols
carbolic1448323carbolic
carbolics1546723carbolics
carbonic1439993carbonic
carbonous1347063carbonous
carcass11310513carcass
carcels114516063carcels
carders104820353carders
cardias10715113cardias
cardon94120853cardo_n
cardoon104813813cardoon
cardoons113411943cardoons
cards85137933car__ds
careens94514703careens
careers95218783careers
carers85133963car_ers
cares77369183car__es
caress85720263car_ess
carets85330773car_ets
carfuls1249133carfuls
cargo85322073cargo__
carhop133610763carho_p
caribes113715643caribes
caribou1156993caribo_u
carices114220953carices
caries85147623car_ies
carinas93622403carinas
carioca1139683carioca
cariocas1239663cariocas
cariole9818343cariole
carioles10817073carioles
caritas93316953caritas
carks115534213car__ks
carles85435083car_les
carless95118493carless
carlins93921913carlins
carload1039783carload
carloads1138393carloads
carls77037423car__ls
carnets93918403carnets
carney115315703carney_
carnies94123963carnies
carns75937563car__ns
carny105822923car_ny_
carob95325223car_o_b
caroch13911763car_och
carol75128613car_o_l
caroli85918233car_oli
carolus94612603carolus
carom95025563car_o_m
carouse9614423car_ouse
carpals113414623carpals
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carpool1139223carpool
carpools1237883carpools
carport11316033carport
carports1238943carports
carps96932253car__ps
carpus105514303car_pus
carrels95117303carrels
carries94328013carries
carrions10312453carrions
carroch1437093carroch
carrom10513403carro_m
carrot8423123carro_t
carroty1248943carroty
carrs75730853car__rs
carry105823783car_ry_
carryon1237033carryon
carryons1337103carryons
cars67364763car___s
carses85233653car_ses
cartels94618123cartels
carters95327253carters
cartes86239473car_tes
carton84522663carto_n
cartoon94114463cartoon
cartoons104012803cartoons
cartop104213563carto_p
carts78946293car__ts
carvels124914593carvels
carvers124817533carvers
carves115128453car_ves
casbahs1436463casbahs
caseous9312513caseous
cashoos12310793cashoos
castors94919443castors
catboat11412243catboat
catboats1247873catboats
cations94524143cations
causeys12387223causeys
cays95437673ca___ys
ceros74726073cer_o_s
cerous85821203cer_ous
chaebols1544723chaebols
chariots1339393chariots
charleys1695633charleys
charpoy1735713charpoy_
charros124312143charro_s
choirboys1941903choirboys
cibols1039523c_ibols
cirrous93111063cirrous
clarions10310493clarions
claroes93113733clar_oes
claros84015113clar_o_s
cloys104916943c__loys
colbys13407153colb_ys
combos125316613combo_s
convoys15267023convoys
copyboys2042663copyboys
corbans11313173corbans
corbels113813593corbels
corbies113520123corbies
corby125018533corb_y_
cordons104415763cordons
cormous11312353cormous
cowboy1637063cowboy_
coys97537243c___oys
crabby15346753crabby_
crabs95421393crab__s
cramboes1436543cramboes
crambos1336783crambo_s
cratons94316033cratons
crayons12439233crayons
crocs95722433c_r_ocs
crooks124914413c_rooks
croons85418423c_roons
crops96125233c_r_ops
cross75124503c_r_oss
crows105727313c_r_ows
cruors838633c_ruors
curbers115514383curbers
curbs94821653curb__s
curios83218333curio_s
curious93813563curious
cursors93910023cursors
czardoms2243743czardoms
darbars10510093darbars
darbies104216983darbies
darbs85323263darb__s
darkeys15356533darkeys
earbuds1044633earbuds
faros85532023far_o_s
farrows13259783farrows
flyboys18112943flyboys
gambols1238593gambols
garbles104016923garbles
garboil1036513garboil
garboils1145663garboils
garbs86321413garb__s
garcons102411643garcons
garrons82713463garrons
garveys14124463garveys
harbor11410723harbo_r
harbour1247053harbour
harbours1346923harbours
harlots103413293harlots
harrows132611033harrows
hautboys1642773hautboys
jabots1538883ja_bots
jargons1558203jargons
jarveys20123413jarveys
jerboas1636163jerboas
kabobs14439303ka_bobs
karoos102415803kar_oos
kaross101910013kar_oss
karroos1139313karroos
labors84016413la_bors
lardons83914493lardons
largos74815063largo_s
lowboys1534213lowboys
mamboes135011823mamboes
mambos125414493mambo_s
marabous1249063marabous
marbles114516653marbles
marbly134111933marbly_
margays1337493margays
marmots11311513marmots
maroons92615553maroons
marrons93216973marrons
marrows122911823marrows
nabobs10388213na_bobs
narcos86714203narco_s
narrows10258843narrows
pageboys1643183pageboys
paperboys1843073paperboys
parboil1138323parboil
parboils1237433parboils
pardons103817623pardons
pareos87023773pareo_s
pargos95719043pargo_s
parlays123910453parlays
parleys125212373parleys
parlors9312913parlors
parlous9414293parlous
parols84722613par_ols
parous84024163par_ous
parrots9312743parrots
parsons93516873parsons
partons94620513partons
parvos116614753parvo_s
playboys1843653playboys
poboys1397313_poboys
potboys1475273potboys
sabots8314703sa_bots
sambos104315193sambo_s
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sar_ods
saros55238063sar_o_s
sartors7314963sartors
savoys12427893sa_voys
scabrous1245993scabrous
scarious10610203scarious
stroys95914603str_oys
taboos83815423ta_boos
tabors84517113ta_bors
tallboys1374623tallboys
tannoys1055553tannoys
tarboosh1343143tarboosh
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarots66422993tar_ots
tarpons92612203tarpons
tomboys1435713tomboys
troys86418613_tr_oys
turbos8910783turbo_s
turbots988023turbots
various103113103various
varooms1248883varooms
warbles123215563warbles
yarrows13277853yarrows

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273736.93619323.4
3Display Results3733730.1402664.3
 (SQL Overall)1786913737.23224708.4
 
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.