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

170 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
caracals1231076(None) 
caracal11312511caracal_
caracols12310411caracols
caraculs1238031caraculs
carabaos1238082carabaos
caracara1247262caracara
caracaras1346862caracaras
caracks152211562carac_ks
caracol11310422caracol_
caracole12310362caracole
caracoles13310082caracoles
caracul1138822caracul_
caramels1238802caramels
caravans1338622caravans
caravels1337442caravels
caraways1636952caraways
carcass11310512car_cass
carcels114516062car_cels
carpals113414632car_pals
ceramals1246512ceramals
craals84113302c_ra_als
curacaos1244922curacaos
maracas11313772maraca_s
abacas104414723_abaca_s
apicals1159923_apicals
arecas84817443_areca_s
argals75517713_ar_gals
arrayals1154483arrayals
atabals938413_atabals
barcas101016603bar_ca_s
berascals1343503berascals
cabalas113516003cabala_s
cabals104020153c__abals
cabanas112413033cabana_s
cacaos104616183c__acaos
cacas95627983c__aca_s
caecal103713733ca_ecal_
calamars1238133calamars
calcars11312653ca_lcars
camails11311753cama_ils
canals84421673c__anals
cancans11311873ca_ncans
cancels114113313ca_ncels
cantals93919573ca_ntals
capitals12209453capitals
caporals1238923caporals
carabao1139673caraba_o
carabids1338193carabids
carabins12312363carabins
carack142113173carac__k
caracoled1445993caracoled
caracoler1346433caracoler
caracolers1445143caracolers
carafes125015703cara_fes
caragana1146283caragana
caraganas1245793caraganas
caramel11310253caramel_
carapace1446093carapace
carapaces1546053carapaces
carapax1835793carapa_x
carapaxes2044833carapaxes
carates95630613cara_tes
carats85929023car__ats
caravan1239233carava_n
caravel1238213caravel_
caraway1538133carawa_y
carbachols1942783carbachols
carbamyls1843033carbamyls
carbaryls1644013carbaryls
carcase11312743car_case
carcases12313093carcases
carcel105018673car_cel_
cardcase1345983cardcase
cardcases1446513cardcases
cardiacs1376923cardiacs
cardias10715123cardia_s
cardinals1248003cardinals
carfuls1249133car_fuls
carices114220953caric_es
carinal94318243carinal_
carinas93622413carina_s
cariocas1239663carioca_s
caritas93316963carita_s
carjacks2345573carjac_ks
carloads1138393carloads
carls77037423car___ls
carnal83919213car_nal_
carnivals1444503carnivals
caroaches1637793caroaches
caroches15710693caroches
carols85124983car__ols
carousals1165343carousals
carpal103716253car_pal_
carpale113414353car_pale
carpels115315463car_pels
carpools1237883carpools
carracks1637713carrac_ks
carrells10359273carrells
carrels95117303car_rels
carryall1343913carryall
carryalls1443523carryalls
cartels94618123car_tels
carvacrols1752013carvacrols
carvels124914593car_vels
casabas1139983casaba_s
casavas1237823casava_s
casuals91410533ca_suals
catcall1139153ca_tcall
catcalls1238323catcalls
causals91411183ca_usals
cavallas1366843cavallas
ceramal1138843ceramal_
cercal10314123cer_cal_
cereals9313173cer_eals
characids1745263characids
characins1647593characins
charcoals16174683charcoals
clericals1345353clericals
cloacal1135163cloacal_
cloacas1136233cloaca_s
coracle112011723corac_le
coracles121811163coracles
corals85325143cor__als
cordials1139633cordials
coronals103312913coronals
corrals93713853cor_rals
craal74117753c_ra_al_
crackle153611253c_rackle
crackles164111273c_rackles
crackly18397703c_rackly
cracks144817003c_rac_ks
cravats1237403c_ravats
crawls114712083c_ra_wls
curacao1146293curaca_o
curacies12311763curacies
curacoas1246033curacoas
curaras93911953curara_s
curtals93111623cur_tals
earaches13411313earaches
faradays1544273faradays
farfals13268503far_fals
faucals12326563fa_ucals
fracas11311993_fraca_s
fractals1346133_fractals
graals74112913_gra_als
hartals10313023har_tals
jacals1539873__jacals
karakuls1142083karakuls
kraals10378433_kra_als
maraca10314153maraca__
marascas1247383marasca_s
marcels113212373mar_cels
marshals1337783marshals
narwals1036983nar_wals
narwhals1443613narwhals
palatals1037773palatals
parasails1147583parasails
parasols1039263parasols
parcels113712663par_cels
parrals94414573par_rals
partials101911963partials
pascals11610013pa_scals
patacas11311003pataca_s
radicals112610163radicals
rascals959663ra_scals
ratals64219583__ratals
taramas9612703tarama_s
tarsals72512603tar_sals
uracils939373_uracils
warragals1343473warragals

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621708.01618233.8
3Display Results1701700.0762236.8
 (SQL Overall)1786911708.51220992.8
 
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.