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

401 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
charros12431214(None) 
charro114212951charro_
charrs115219181charr_s
churros12427581churros
carbos105122262c_arbos
cargos94619182c_argos
carrom10513402c_arrom
carroms11512402c_arroms
carrot8423122c_arrot
carrots9714622c_arrots
carrs75730852c_arr_s
chadors1338722chadors
chairs114916172chair_s
chakras16428482chakras
chaos105622862cha__os
charas114223592cha_ras
chards125119722cha_rds
chares115631802cha_res
charges134615982charges
chariot12316212chariot
chariots1339392chariots
charkas164810952charkas
charks155219702cha_rks
charms135218832cha_rms
charpoy1735712charpoy
charpoys1834532charpoys
charr104821782charr__
charred134614482charred
charry145012112charr_y
chars105936632cha_r_s
charts115823092cha_rts
cheeros123711632cheeros
chiros114617772ch_iros
chirres123812252chirres
chirrs114514982chirr_s
churro11448352churro_
churrs115111512churr_s
claros84015112cla_ros
cuatros938252cuatros
gharris11306432gharris
harrow122610772_harrow
harrows132611032_harrows
pharos11312062pha_ros
arras55626133__arras
arris56824683__arris
arrow83414883__arrow
arrows92813483__arrows
arvos86015663__arvos
barres84427543_barres
barrios9310773_barrios
barrow114512763_barrow
barrows123411683_barrows
bharals1236733bharals
bizarros1942713bizarros
burros85114993_burros
cacaos104616183c_acaos
cadres94017923c_adres
cairds96411513c_airds
cairns85313303c_airns
calos74431903c_a_los
cameos105818003c_ameos
camos95927613c_a_mos
campos125217953c_ampos
cansos84915383c_ansos
cantos84826973c_antos
capos94826073c_a_pos
capris10415073c_apris
carats85929023c_arats
carbo94923843c_arbo_
carbon104919043c_arbon
carbons115418943c_arbons
carboy134914183c_arboy
carboys144711783c_arboys
carbs96031463c_a_rbs
cardon94120853c_ardon
cardons104519933c_ardons
cards85137933c_a_rds
carers85133953c_arers
cares77369183c_a_res
caress85720263c_aress
carets85330773c_arets
cargo85322073c_argo_
cargoes104415223c_argoes
carhop133610763c_arhop
carhops14329703c_arhops
caries85147623c_aries
carious93320283c_arious
carks115534213c_a_rks
carles85435083c_arles
carls77037423c_a_rls
carns75937563c_a_rns
carob95325223c_a_rob
carobs104818103c_arobs
carol75128613c_a_rol
carols85124983c_arols
carom95025563c_a_rom
caroms105619573c_aroms
carps96932253c_a_rps
carpus105514303c_arpus
carr65434703c_arr__
carrel84718633c_arrel
carrels95117303c_arrels
carries94328013c_arries
carrion9312673c_arrion
carrions10312443c_arrions
carroch1437093c_arroch
carroty1248943c_arroty
carry105823783c_arr_y
carryon1237033c_arryon
carryons1337103c_arryons
cars67364763c_a_r_s
carses85233653c_arses
cartes86239473c_artes
carton84522663c_arton
cartons94122473c_artons
cartop104213563c_artop
carts78946293c_a_rts
carves115128453c_arves
catarrhs1344333catarrhs
ceros74726073c__eros
chablis14368553chablis
chabuks1843733chabuks
chacmas1637993chacmas
chadars1338273chadars
chador1238663cha_dor
chadri1238133chadr_i
chads116122233cha__ds
chaebol1444943chaebol
chaebols1544723chaebols
chafers154512723chafers
chafes145017913cha_fes
chaffs17459613cha_ffs
chagrin1337883chagrin
chagrins1437063chagrins
chaines124518733chaines
chains114819703cha_ins
chair105519633chair__
chaired134211243chaired
chais107530313cha__is
chaises124317493chaises
chakra15437533chakr_a
chalahs15289883chalahs
chaldron1445773chaldron
chaldrons1545493chaldrons
chalehs15268803chalehs
chalets122813473chalets
chalks155412143cha_lks
challas124414123challas
challis124613463challis
challot123613263challot
chalot113020133cha_lot
chamfron1844493chamfron
chamfrons1944373chamfrons
chamiso14348653chamiso
chamisos15307423chamisos
chamois143512173chamois
champs154915683cha_mps
chams126028503cha__ms
chances145218093chances
chancres15429363chancres
chancrous1644873chancrous
chanfron1644803chanfron
chanfrons1744623chanfrons
changes134517583changes
changs125215373cha_ngs
chanson1238043chanson
chansons1337473chansons
chantor123710313chantor
chantors133710253chantors
chants115020393cha_nts
chao95727313cha__o_
chaoses124715113chaoses
chapels14429153chapels
chaperon1547353chaperon
chaperons1646883chaperons
chapes135421873cha_pes
chaps125326063cha__ps
char95132153cha_r__
charade13129903charade
charades141310843charades
charases131312753charases
charbroil1642993charbroil
charbroils1742363charbroils
charcoal15165733charcoal
charcoals16174673charcoals
chard116124743cha_r_d
chare105231983cha_r_e
chared125423693cha_red
charge125114213cha_rge
charged144614023charged
charger133914063charger
chargers144011313chargers
charier124317903charier
chariest13315503chariest
charily15310283charily
charing133721323charing
charism14712203charism
charisms15710263charisms
charity15311023charity
chark144222713cha_r_k
charka154011703cha_rka
charked174814013charked
charkha19405153charkha
charkhas20285023charkhas
charley15118273charley
charleys1695633charleys
charlie123011923charlie
charlies133414223charlies
charlock1944393charlock
charlocks2044073charlocks
charm126124663cha_r_m
charmed154714243charmed
charmer144913663charmer
charmers154211323charmers
charnel124010053charnel
charnels13328173charnels
charpai1436623charpai
charpais1536923charpais
charqui2143993charqui
charquis2243913charquis
charrier1378683charrier
charriest1438253charriest
charring142913163charring
chart105038283cha_r_t
charted135116853charted
charter123918303charter
charters134115563charters
chartist131112133chartist
chary135023133cha_r_y
chasers123714893chasers
chases115128233cha_ses
chasms135513143cha_sms
chasses124017503chasses
chassis123910663chassis
chatroom1596263chatroom
chatrooms1685103chatrooms
chats105730093cha__ts
chaunts1267083chaunts
chawers154412033chawers
chaws135022463cha__ws
chays135319743cha__ys
chazans21268123chazans
cheapos14418513cheapos
cheerios13317573cheerios
cheero114712933cheero_
cheers114518913cheer_s
chemos13311723ch_emos
cheroot12413693cheroot
cheroots1348193cheroots
cherries131812973cherries
cherry144810763cherr_y
cherts115617233ch_erts
cherubs1434553cherubs
chevres15379793chevres
chevron1575783chevron
chevrons1665463chevrons
chicos134614833ch_icos
chinos115018693ch_inos
chirks155414843ch_irks
chirms135113983ch_irms
chiro105320343ch_iro_
chirps135414003ch_irps
chirr105015903chirr__
chirre114111853chirr_e
chirred133612123chirred
chirren12388743chirren
chirrup14123833chirrup
chirrups15133043chirrups
chirus114615693ch_irus
chlorous1339213chlorous
choirs114911873choir_s
cholos114716853ch_olos
chorals124614103chorals
chords125214633ch_ords
choreas124414203choreas
chores114828023ch_ores
chorion12311763chorion
chorions13310653chorions
chorizos2245483chorizos
chorus115014763ch_orus
chromos142610273chromos
churls115411073ch_urls
churns114910233ch_urns
churr104512853churr__
churred13409173churred
ciceros1158573ciceros
cirrose937473c_irrose
cirrous93111063c_irrous
cirrus8349173c_irrus
clamors11710093clamors
clarets94111103clarets
claries93422203claries
clarion9311663clarion
clarions10310493clarions
claro75018693cla_ro_
claroes93113733claroes
crambos1336783crambos
cuatro838413cuatro_
curaras93911943curaras
curares94916853curares
curaris94114773curaris
curios83218333c_urios
currs75624393c_urr_s
czardas1934673czardas
czardom2144183czardom
czardoms2243743czardoms
czars164812913cza_r_s
dharmas1356503dharmas
dharnas1155373dharnas
echards1337963echa_rds
faros85532023_fa_ros
farrow12309973_farrow
farrows13259783_farrows
garron73113493_garron
garrons82713463_garrons
gharri10386163gharr_i
gharries12318203gharries
gharry13546273gharr_y
gnarrs7407663gnarr_s
haars85620473_haar_s
hadron102913753_hadron
hadrons113314303_hadrons
haeres94017033_haeres
hairdos1136823_hairdos
hairs86225173_hair_s
hallos95425103_hallos
halos85230253_ha_los
harass9313943_harass
harbor11410723_harbor
harbors12412413_harbors
hards96435653_ha_rds
harems115513823_harems
hares86255543_ha_res
harks126333433_ha_rks
harlot94422803_harlot
harlots103413293_harlots
harls85634503_ha_rls
harms106829013_ha_rms
harps105926863_ha_rps
harries103525493_harries
harry115322953_harr_y
harts88441593_ha_rts
heros84930863_h_eros
horror988723_horror
horrors1078693_horrors
hydros13279363_hydros
karoos102415803_karoos
karroo10410013_karroo
karroos1139313_karroos
largos74815063_largos
macros104017013_macros
marron83717543_marron
marrons93216973_marrons
marrow112812603_marrow
marrows122911813_marrows
morros83714673_morros
narcos86714203_narcos
narrow9269143_narrow
narrows10258843_narrows
pareos87023773_pareos
pargos95719043_pargos
parrot8320663_parrot
parrots9312743_parrots
parrs75928673_parr_s
parvos116614753_parvos
pharaoh1545023pharaoh
pharaohs1644493pharaohs
quartos16328733quartos
sargos74318273_sargos
saros55238063_sa_ros
scherzos2243693scherzos
shackos16429023shackos
shairds11216263shairds
shairns10276783shairns
shakos134912183sha_kos
shammos14307203shammos
shamos114216983sha_mos
shards104319173sha_rds
sharers104720623sharers
shares95236413sha_res
sharias102516003sharias
sharifs13279903sharifs
sharks135019723sha_rks
sharns95516983sha_rns
sharps115516083sha_rps
sherris10168793sherris
shirrs94413173shirr_s
sparrow1234263sparrow
sparrows1344803sparrows
taros55640823_ta_ros
tarres64723043_tarres
thairms1244453thairms
tharms115712243tha_rms
thermos124610753thermos
whackos19375263whackos
wharfs1546373wha_rfs
wharves16457133wharves
whirrs12408593whirr_s
yarrow12287933_yarrow
yarrows13277853_yarrows
zamarros1942683zamarros

Search took 9 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 Limit1340274017.78017227.1
3Display Results4014010.1402864.3
 (SQL Overall)1786914018.07622126.2
 
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.