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

193 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
carioca113968(None) 
cariocas1239661cariocas
carbora11310702carbora
carina84325332cari_na
cariole9818342cariole
carious93320282carious
caroch13911762car_och
carroch1437092carroch
curiosa9346642curiosa
manioca11358942manioca
tapioca1144632tapioca
variola1068892variola
areca75618633_ar_eca
areola6813673_areola
aria46245423_ari__a
ariose64818723_ariose
ariosi64313033_ariosi
arioso64312403_arioso
arista6415293_arista
arnica8310443_arnica
aroma71220143_ar_oma
arroba898663_arroba
barca91319433bar__ca
baric96125693bari_c_
barilla9310333barilla
barista9310823barista
cabrilla1245833cabrilla
cabriole1276933cabriole
caca85528083ca___ca
caeca93915133ca__eca
caeoma1039033ca_eoma
calico103414433cali_co
calicos113913493calicos
camion103917193camio_n
camions113916133camions
camisa103114323cami_sa
camisia112810243camisia
canola8313623ca_nola
canzona1836073canzona
capita102913773capi_ta
capric12411803capri_c_
capricci1342653capricci
caprice1349683capri_ce
capriole1276913capriole
caprock1736813caprock
caracal11312513car_acal
carack142113173car_ack
caracol11310423caracol
caramba1336893caramba
carbo94923843carbo__
carbon104919043carbo_n
carbons115418943carbons
carboras12311583carboras
carbos105122263carbo_s
carboy134914183carbo_y
carboys144711783carboys
carcinoma1543773carcinoma
cardia9916383car_dia
cardiac1278823cardiac_
cardiacs1376923cardiacs
cardio9915673cardio__
cardioid1247453cardioid
cardon94120853cardo_n
cardons104519943cardons
cardoon104813813cardoon
cargo85322073cargo__
cargoes104415223cargoes
cargos94619183cargo_s
carhop133610763carho_p
carhops14329703carhops
caribe103416753cari_be
caribes113715643caribes
caribou1156993caribou
caribous1258823caribous
carices114220953carices
caried94528693cari_ed
caries85147623cari_es
carinae94318593carinae
carinal94318243carinal
carinas93622413carinas
caring95137993cari_ng
carioles10817073carioles
caritas93316963caritas
carjack2246153carjack
carload1039783carload
carnivora1442493carnivora
caroach1488863caroach
carob95325223car_o_b
carobs104818103car_obs
caroche1469243car_oche
carol75128613car_o_l
caroli85918233car_oli
carols85124983car_ols
carom95025563car_o_m
caroms105619573car_oms
carpool1139223carpool
carport11316033carport
carrack1548753carrack
carriole1089863carriole
carrion9312673carrio_n
carrions10312453carrions
carritch1543483carritch
carrom10513403carro_m
carroms11512403carroms
carrot8423123carro_t
carrots9714623carrots
carroty1248943carroty
carsick1536343carsick
carton84522663carto_n
cartons94122473cartons
cartoon94114463cartoon
cartop104213563carto_p
cartouch15113513cartouch
casita82913703casi_ta
cassock1545953cassock
cation83925503catio_n
cations94524143cations
ceria75125363ceri__a
ceric94023093ceri_c_
chariot12316213chario_t
chariots1339393chariots
charisma1576363charisma
charlock1944393charlock
chica125818263c_hi_ca
chrisma1456823chrisma
chroma132912473chr_oma
circa9311403c__irca
clarion9311663clario_n
clarions10310493clarions
coca88030643c___oca
cordoba1255743cordoba
coria75828323cori__a
corona83817403cor_ona
corpora1139353corpora
crapola1136913crapola
crick135118753c_ri_ck
crissa837623c_rissa
crista8311803c_rista
croc85723733c_r_oc_
croci95818133c_r_oci
crock135921993c_r_ock
crocs95722433c_r_ocs
curacoa1146223curacoa
curia74523783curi__a
curio74221213curio__
curios83218333curio_s
curious93813563curious
czarina1845953czari_na
czaritza1891953czaritza
daric85623123dari_c_
darics94314113dari_cs
dariole8711163dariole
earlock1336923earlock
erica7316543_eri_ca
farina94618233fari_na
farinha13357063farinha
hariana10310243hariana
haricot12311963haricot
harissa1035503harissa
jarina134014063jari_na
lorica8310443lori_ca
mandioca1354113mandioca
manioc103914823manioc_
maniocas12298473maniocas
maniocs113611443maniocs
maraca10314153mar_aca
marasca1136823marasca
maria75032883mari__a
marimba1354983marimba
marina84623413mari_na
mariposa1243703mariposa
myrica1336833myri_ca
narcoma1145823narcoma
naric76824173nari_c_
oarlock1336123oarlock
ocarina948033ocari_na
paprica1337003papri_ca
parfocal1565393parfocal
rioja1236303__rioja
sarcoma1147403sarcoma
scabiosa1262853scabiosa
scariose1037593scariose
scarious10610203scarious
tapiocas1244783tapiocas
taroc75721643tar_oc_
tarocs84615663tar_ocs
varia85824203vari__a
variolar1176343variolar
variolas1168533variolas
variole10711593variole
various103113103various
warlock1636293warlock
zariba1736983zari_ba

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.453394461.4
2DLD Change Limit1340271937.06318975.9
3Display Results1931930.0802412.5
 (SQL Overall)1786911937.59623524.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.