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

181 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
caracol1131042(None) 
caracal11312511caracal
caracole12310361caracole
caracols12310411caracols
caracul1138821caracul
caracals12310762caracals
carack142113172carac_k
caracks152211562caracks
caracoled1445992caracoled
caracoler1346432caracoler
caracoles13310082caracoles
caraculs1238032caraculs
caramel11310252caramel
caravel1238212caravel
carbachol1842772carbachol
carcel105018672car_cel
carol75128612car__ol
carpool1139222carpool
carvacrol1652072carvacrol
curacoa1146222curacoa
parasol939552parasol
amatol838693_amatol
arco68331543_ar_co_
argol65317263_ar_gol
cabal95222153caba__l
cacao95420003caca_o_
cacaos104616183caca_os
caecal103713733ca_ecal
calico103414433calico_
calicos113913493calicos
camail10314833cama_il
camphol1645793camphol
canal75428043cana__l
cancel105316683ca_ncel
capitol11258283capitol
carabao1139673carabao
carabaos1238083carabaos
carabid12311333carabid
carabin11313213carabin
caracara1247263caracara
caracolers1445143caracolers
caracoling1545633caracoling
caracolled1543023caracolled
carafe115416163cara_fe
carafes125015703carafes
caramba1336893caramba
carambola1542853carambola
caramels1238803caramels
carapax1835793carapax
carassow1343253carassow
carat75048793cara__t
carate84734003cara_te
carates95630613carates
carats85929023cara_ts
caravan1239233caravan
caravels1337443caravels
caraway1538133caraway
carbachols1942783carbachols
carbamoyl1851893carbamoyl
carbamyl1743103carbamyl
carbaryl1544423carbaryl
carbazole2243773carbazole
carbinol1245783carbinol
carbo94923843car_bo_
carbon104919043car_bon
carbos105122263car_bos
carboy134914183car_boy
carcajou19123583carcajou
carcase11312743carcase
carcass11310513carcass
carcels114516063car_cels
cardamom1543883cardamom
cardamon1345553cardamon
cardio9915673cardio_
cardon94120853car_don
cardoon104813813cardoon
careful1249113careful
carful11610973car_ful
cargo85322073car_go_
cargos94619183car_gos
carhop133610763car_hop
caribou1156993caribou
carices114220953carices
carinal94318243carinal
carioca1139683carioca
cariole9818343car_iole
carjack2246153carjac_k
carjacks2345573carjacks
carl65144783car___l
carnal83919213car_nal
caroach1488863caroac_h
carob95325223car__ob
caroch13911763caroc_h
caroche1469243caroche
caroli85918233car__oli
carols85124983car__ols
carom95025563car__om
carpal103716253car_pal
carpel105418473car_pel
carpools1237883carpools
carrack1548753carrac_k
carracks1637713carracks
carrel84718633car_rel
carrell94610473carrell
carriole1089863carriole
carrion9312673carrion
carroch1437093carroch
carrom10513403car_rom
carrot8423123car_rot
carryon1237033carryon
cartel85022533car_tel
carton84522663car_ton
cartoon94114463cartoon
cartop104213563car_top
carvacrols1752013carvacrols
carvel114817573car_vel
catacomb1643663catacomb
catalo8314853catalo_
catalog1038003catalog
catalos9414163catalos
catcall1139153catcall
catechol1544613catechol
ceramal1138843ceramal
cercal10314123cer_cal
characid1646863characid
characin1547993characin
charcoal15165743char_coal
cloacal1135163cloacal
coracle112011723coracle
coracoid1348163coracoid
coral76033453cora__l
corncob1345663corncob
craal74117753c_ra_al
crack134120533c_rac_k
crackle153611253c_rackle
crackly18397703c_rackly
cracks144817003c_racks
cracky175010223c_racky
crapola1136913c_rapola
craton84517193c_raton
crawl104916713c_ra_wl
crayon114110003c_rayon
cresol8310213c_resol
curacao1146293curacao
curacaos1244923curacaos
curacoas1246033curacoas
curacy1339593curac_y
curator9312213curator
danazol1743253danazol
earache1239333earache
garcon92912483gar_con
girasol874623girasol
guaiacol1151863guaiacol
haricot12311963haricot
karakul1042553karakul
macaco1247853macaco_
macacos1338083macacos
marabou1147493marabou
maraca10314153marac_a
maracas11313773maracas
marcel103714853mar_cel
narco76718243nar_co_
narcos86714203nar_cos
parabola1246653parabola
parachor1546663parachor
parador103311413parador
parados103816053parados
paradox17358173paradox
parafoil1345973parafoil
paragon10311023paragon
paramo102614643paramo_
paramos113213513paramos
parasols1039263parasols
parcel103915473par_cel
parol74826273par__ol
racon75422143__racon
turaco839453turaco_
turacos938643turacos
turacou945513turacou
uracil8311543_uracil
varactor1345703varactor

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.390458182.1
2DLD Change Limit1340271816.93619323.4
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.38924183.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.