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

427 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
carroms1151240(None) 
caroms105619571ca_roms
carrom10513401carrom_
carrots9714621carrots
arrows92813482_arrows
barrooms1237892barrooms
barrows123411682barrows
carbons115418942carbons
carbos105122262carbo_s
carboys144711782carboys
cardons104519932cardons
cargoes104415222cargoes
cargos94619182cargo_s
carhops14329702carhops
carious93320282carious
carobs104818102ca_robs
carols85124982ca_rols
carom95025562ca_rom_
carrels95117302carrels
carries94328012carries
carrions10312442carrions
carroch1437092carroch
carromed1338562carromed
carrot8423122carro_t
carroty1248942carroty
carrs75730852carr__s
carryons1337102carryons
cartons94122472cartons
charros124312142charro_s
cirrous93111062cirrous
czardoms2243742czardoms
farrows13259782farrows
garrons82713462garrons
harrows132611032harrows
karroos1139312karroos
marrams11310122marrams
marrons93216972marrons
marrows122911812marrows
narrows10258842narrows
parrots9312742parrots
varooms1248882varooms
yarrows13277852yarrows
acarpous1245313acarpous
acerous9513333acerous
across8312643_across
aprons8316993_aprons
arbors84717873_arbors
ardors74416863_ardors
argols74514613_argols
argons75018203_argons
argots74116023_argots
armors85017813_armors
arms66137493_a_r_ms
aroma71220143_a_roma
aromas81018613_a_romas
arras55626133_arr_as
arrays95311683_arrays
arris56824683_arr_is
arroba898663_arroba
arrobas969213_arrobas
arrow83414883_arro_w
arrowy12288273_arrowy
arroyo936963_arroyo
arroyos1036533_arroyos
arsons63917213_arsons
arums75517833_a_rums
arvos86015663_arvo_s
atoms76817563_a_toms
aurous64119263_aurous
aurums849383_aurums
axioms15408053_axioms
barhops14288113barhops
bariums1139143bariums
barlows12259973barlows
barms96128463ba_r_ms
barons85025383ba_rons
barrels94514363barrels
barrens94414323barrens
barres84427543barr_es
barrets94917103barrets
barrios9310773barrios
barroom1139373barroom
barrow114512763barro_w
baryons121010473baryons
bazooms20285383bazooms
borrows12349253borrows
brooms104915873_brooms
burros85114993burro_s
burrows12399093burrows
cabobs124311883ca_bobs
cacaos104616183cacao_s
cachous14312563cachous
cadres94017923cadr_es
caeoma1039033ca_eoma
caeomas1138393ca_eomas
cahoots1238473cahoots
cahows14399123ca_hows
cairds96411513cair_ds
cairns85313303cair_ns
caldrons1138063caldrons
callous93516593callous
calms95222353ca__lms
calos74431903ca_lo_s
caltrops12307863caltrops
cameos105818003cameo_s
camions113916133camions
camos95927613ca_mo_s
campos125217953campo_s
cams87047283ca___ms
candors104216763candors
cannons94412883cannons
canoes84725883ca_noes
canons85522063ca_nons
canorous10310193canorous
cansos84915383canso_s
cantons95221203cantons
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
capons104119503ca_pons
capos94826073ca_po_s
capris10415073capr_is
caprock1736813caprock
caprocks1835943caprocks
captors113914983captors
caracks152211563caracks
caracols12310413caracols
carafes125015703carafes
carates95630603carates
carats85929023ca_rats
carbo94923843carbo__
carbon104919043carbo_n
carbora11310703carbora
carboras12311573carboras
carboy134914183carbo_y
carbs96031463ca_r_bs
carcass11310513carcass
carcels114516063carcels
cardamoms1643513cardamoms
carders104820353carders
cardias10715093cardias
cardon94120853cardo_n
cardoon104813813cardoon
cardoons113411943cardoons
cards85137933ca_r_ds
careens94514703careens
careers95218783careers
carers85133953ca_rers
cares77369183ca_r_es
caress85720263ca_ress
carets85330773ca_rets
carfuls1249133carfuls
cargo85322073cargo__
carhop133610763carho_p
caribes113715643caribes
caribous1258823caribous
carices114220953carices
caries85147623ca_ries
carinas93622383carinas
carioca1139683carioca
cariocas1239663cariocas
cariole9818343cariole
carioles10817063carioles
caritas93316943caritas
carks115534213ca_r_ks
carles85435083ca_rles
carless95118493carless
carlins93921913carlins
carload1039783carload
carloads1138393carloads
carls77037423ca_r_ls
carnets93918403carnets
carneys124310543carneys
carnies94123963carnies
carns75937563ca_r_ns
carob95325223ca_ro_b
caroch13911763ca_roch
carol75128613ca_ro_l
caroli85918233ca_roli
carolus94612603carolus
caromed123713623ca_romed
carouse9614423ca_rouse
carpals113414623carpals
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carpool1139223carpool
carpools1237883carpools
carport11316033carport
carports1238943carports
carps96932253ca_r_ps
carpus105514303ca_rpus
carr65434703carr___
carrack1548753carrack
carracks1637713carracks
carrel84718633carr_el
carrell94610463carrell
carrells10359263carrells
carried103717153carried
carrier93619583carrier
carriers103614203carriers
carriole1089863carriole
carrioles1169473carrioles
carrion9312673carrion
carroches1665893carroches
carroming1437673carroming
carrotin102210883carrotin
carrotins11239953carrotins
carrousel1174373carrousel
carry105823783carr__y
carryon1237033carryon
carryout1346783carryout
carryouts1443433carryouts
cars67364763ca_r__s
carses85233653ca_rses
cartels94618123cartels
carters95327243carters
cartes86239473ca_rtes
carton84522663carto_n
cartoon94114463cartoon
cartoons104012803cartoons
cartop104213563carto_p
carts78946293ca_r_ts
carvels124914593carvels
carvers124817533carvers
carves115128453ca_rves
caseous9312513caseous
cashoos12310793cashoos
castors94919433castors
cations94524143cations
cavorts1237933cavorts
celoms10412123c_eloms
ceriums1139473ceriums
ceros74726073c_ero_s
cerous85821203c_erous
chariots1339393chariots
charisms15710263charisms
charms135218833char_ms
charpoys1834533charpoys
charro114212953charro__
charrs115219183charr__s
chatrooms1685103chatrooms
chirms135113983chir_ms
chiros114617773chiro_s
chrisms1499143chrisms
chrisoms1566093chrisoms
chroma132912473c_hroma
chromas142512683c_hromas
chrome133214813c_hrome
chromes142914933c_hromes
chromo132811013c_hromo
chromos142610273c_hromos
chromy16309903c_hromy
churros12427583churro_s
cirrose937473cirrose
cirrus8349173cirr_us
citrons92913223citrons
citrous93112983citrous
clarions10310493clarions
claroes93113733claroes
claros84015113claro_s
coatrooms1385413coatrooms
coeloms1139063coeloms
condoms124214083condoms
cordons104415763cordons
cormous11312353cormous
corms95626223c_or_ms
cornrows1345313cornrows
corrals93713853corrals
corries94026783corries
corrode101310573corrode
corrodes111310333corrodes
corrody13136143corrody
crams96229153c__rams
cratons94316033cratons
crayons12439233crayons
creams104715253c_reams
crocs95722433c__rocs
crooks124914413c_rooks
croons85418423c_roons
crops96125233c__rops
crores86121163c_rores
cross75124503c__ross
crows105727313c__rows
cruors838623c_ruors
cuatros938253cuatro_s
cuprous1149743cuprous
cuprums1334453cuprums
curios83218333curio_s
curious93813563curious
curiums1138503curiums
currans9310613currans
curries93723163curries
currs75624393curr__s
cursors93910023cursors
customs11348253customs
czardom2144183czardom_
czarisms2155753czarisms
dacrons103211033dacrons
darkrooms1642913darkrooms
dayrooms1444343dayrooms
eardrops1165303eardrops
eardrums11524483eardrums
earldoms1144223earldoms
earworms1346763earworms
errors63311313_errors
fandoms13229473fandoms
fantoms12189153fantoms
farms106324953fa_r_ms
faros85532023fa_ro_s
farrow12309973farro_w
fathoms1537523fathoms
ferrous1049793ferrous
ferrums1265983ferrums
furrows13327793furrows
garcons102411643garcons
garrets84413623garrets
garron73113493garro_n
garrote8510103garrote
garrotes969363garrotes
grooms94512523_grooms
hadrons113314303hadrons
hansoms12238523hansoms
harbors12412413harbors
hareems12428203hareems
harems115513823ha_rems
harlots103413293harlots
harms106829013ha_r_ms
harries103525493harries
harrow122610773harro_w
horrors1078693horrors
jargons1558203jargons
jarldoms1842943jarldoms
jarrahs1735453jarrahs
karoos102415803ka_roos
kaross101910013ka_ross
karroo10410013karro_o
labrums1175853labrums
ladrons83813193ladrons
lardons83914493lardons
largos74815063largo_s
larrups934733larrups
larums83610533la_rums
macrons113514893macrons
macros104017013macro_s
madtoms1236923madtoms
marmots11311513marmots
maroons92615553maroons
marram10313883marram_
marrers93414313marrers
marries93825283marries
marron83717543marro_n
marrow112812603marro_w
marrowy15236083marrowy
matrons93517633matrons
mirrors938623mirrors
morros83714673morro_s
morrows12318723morrows
narcoma1145823narcoma
narcomas1246043narcomas
narcos86714203narco_s
narrow9269143narro_w
natrons73215663natrons
paramos113213513paramos
pardons103817623pardons
pareos87023773pareo_s
pargos95719043pargo_s
parlors9312913parlors
parlous9414293parlous
parols84722613pa_rols
parous84024163pa_rous
parrals94414573parrals
parrels94713493parrels
parries93925843parries
parrot8320663parro_t
parroty1247863parroty
parrs75928673parr__s
parsons93516873parsons
partons94620513partons
parvos116614753parvo_s
patrols93513513patrols
patrons93818103patrons
perrons93115483perrons
pogroms1237643pogroms
proms95426403__proms
pyrrols1235403pyrrols
ramrods1036583ramrods
randoms102112433randoms
ransoms92410163ransoms
roms67038963___roms
rooms75324683__rooms
sacrums11388043sacrums
safrols1036863safrols
sarcoma1147403sarcoma
sarcomas1247223sarcomas
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sa_rods
saros55238063sa_ro_s
sartors7314953sartors
scabrous1245993scabrous
scarious10610203scarious
sorrows10278403sorrows
sparrows1344803sparrows
stardoms1136793stardoms
taprooms1246663taprooms
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
tarpons92612203tarpons
tarres64723043tarr_es
tarries73324263tarries
tearooms1047843tearooms
terrors73112203terrors
tsardoms1144133tsardoms
tzardoms2043273tzardoms
vagrom1235943vagrom_
various103113103various
varoom11411413varoom_
vrooms11398713_vrooms
wardrooms1544183wardrooms
warerooms1445823warerooms
warms107726853wa_r_ms
warrens103810893warrens
warriors1135363warriors
yarrow12287933yarro_w

Search took 10 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 Limit1340274279.06314788.4
3Display Results4274270.1732468.2
 (SQL Overall)1786914279.39219025.9
 
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.