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

275 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
caprices143989(None) 
caprice1349681caprice_
carices114220951ca_rices
apices104916262_ap_ices
caddices14297852caddices
calices114321692ca_lices
capizes20410372cap_izes
capric12411802capric__
capricci1342652capricci
caprine11314232caprine_
caprioles1376752caprioles
capris10415082capri__s
caprocks1835942caprocks
capsizes2147202capsizes
captives1538622captives
caribes113715642ca_ribes
caries85147622ca_ri_es
carries94328012carri_es
caudices13337342caudices
coppices1638242coppices
coprinces1547482coprinces
cuprites1259022cuprites
matrices12312082matrices
papricas1447052papricas
prices104524542__prices
reprices122913352reprices
varices123313572va_rices
acarines10314343acarines
advices13136933_advices
aeries64737783_aeri_es
amices105018013_a_mices
aperies9423203_aperi_es
aphides134711203_aphides
aplites9314933_aplites
apprises12310963apprises
apprizes2137793apprizes
apres75426403_apr__es
apricot111010183_apricot
apricots1275393_apricots
apsides103911303_apsides
arises65233803_a_rises
arrises71617583_arrises
arrives101311513_arrives
auricles10138333_auricles
avarices1337183avarices
baptises1238923baptises
baptizes2136843baptizes
barites94322333ba_rites
cabbies133115163cabbi_es
cabrioles1376363cabrioles
caddice13327733caddice_
caddies113718383caddi_es
caddises12329353caddises
cadences1338473cadences
cadres94017933cadr__es
calces104420053ca__lces
calcines12314753calcines
calcites12313003calcites
caliches153812273ca_liches
calicles123811433ca_licles
calicoes123911603ca_licoes
calicos113913493ca_licos
calorics122810463caloric_s
calories102919563calori_es
calorizes202312303calorizes
calyces14428803ca_lyces
cambrics1645253cambric_s
camises114218463ca_mises
cammies134016483cammi_es
campfires1844123campfires
camphines1847563camphines
camphires1845783camphires
campsites1546473campsites
canaries10318943canari_es
candies104125613candi_es
canines93724033ca_nines
canticles1339183canticles
capes95441923cap___es
capias10318353cap_i_as
capiases1239253capiases
caplins113515993capli_ns
caponizes2238703caponizes
capotes11314643cap_otes
capouches1843633capouches
cappings15369493cappings
capriccio1452093capriccio
capriccios1551943capriccios
capricious1644223capricious
caprifig1643223caprifig
caprifigs1742703caprifigs
capriole1276913capriole
caprioled1464743caprioled
caprock1736813caproc_k
capsicin1455593capsicin
capsicins1545173capsicins
capsicum1643533capsicum
capsicums1742383capsicums
capsids1239333capsi_ds
capsize2037623capsize_
capsized2255503capsized
capsules1236623capsules
captions123813223captions
captious122810573captious
captive1438973captive_
captures1239443captures
capuches1735513capuches
caracks152211563ca_racks
carafes125015703ca_rafes
carates95630613ca_rates
carbides133111693carbides
carbines123617543carbines
carcel105018673ca_r_cel
carcels114516063ca_r_cels
cares77369183ca_r__es
cargoes104415223ca_rgoes
caribe103416753ca_ribe_
caried94528693ca_ri_ed
carinas93622413ca_rinas
cariocas1239663ca_riocas
carioles10817073ca_rioles
carious93320283ca_rious
caritas93316963ca_ritas
carles85435083ca_r_les
carlines103521663carlines
carmines123617873carmines
carnies94123963ca_rnies
caroches15710693ca_roches
carpings133812393carpings
carracks1637713carracks
carriages1238333carriages
carried103717153carri_ed
carrier93619583carri_er
carriers103614203carriers
carrioles1169473carrioles
carrions10312453carrions
carritches1743083carritches
carroches1665893carroches
carses85233653ca_r_ses
cartes86239473ca_r_tes
carves115128453ca_r_ves
cassines103116613cassines
cassises103811743cassises
catfaces1536963catfaces
catties94023053catti_es
caulicles1344383caulicles
cavies114525003ca_vi_es
cerises94722253c_erises
cerites94823433c_erites
cervices1537133cervices
chalices15310813chalices
chappies172610103chappi_es
choices142010613c_hoices
chorines132917253chorines
cicatrices1343493cicatrices
cilices113814023c_ilices
cimices13279803c_imices
citrines102513133citrines
claries93422203clari_es
clerics1149333cleric_s
codices12512583c_odices
codrives1437663codrives
coerces11311943coer_ces
complices1739253complices
comprises15510943comprises
comprizes2468943comprizes
copies104130313cop_i_es
coppice1537483coppice_
coppiced1734833coppiced
coprince1447093coprince_
cornices12713303cornices
corries94026803corri_es
cortices12615023cortices
cowries124218013cowri_es
cowrites133011593cowrites
crappies142911173crappi_es
crevices1536713crevices
cricks144316053c__ricks
cries75438403c__ri_es
crimes105521583c__rimes
cripes105120873c__ripes
crises84529433c__rises
cruces105117543c__ruces
culices113713123c_ulices
cupric1249123cupric__
cuprite1159683cuprite_
curies84934023c_uri_es
curites93919863c_urites
curricles13105423curricles
curries93723163curri_es
cylices14359283c_ylices
cypres1338523cypr__es
cypreses1535143cypreses
cyprians1544213cyprians
cypruses1534313cypruses
dairies84217733dairi_es
darics94314113da_ric_s
deprives1438393deprives
earpieces1343353earpieces
emprises12311003emprises
emprizes2138133emprizes
fabrics1436093fabric_s
faeries104118993faeri_es
fairies103516043fairi_es
farces115223323fa_r_ces
farcies125317883fa_rcies
garpikes1534373garpikes
hagrides1337623hagrides
haplites1339993haplites
harpies123818323harpi_es
harries103525503harri_es
hayricks2043763hayricks
hayrides1536883hayrides
japeries17311463japeri_es
kauries113613193kauri_es
lapides103012043lap_ides
lapises93513463lap_ises
latices9313763la_tices
latrines8515013latrines
lattices1038383lattices
malices114316623ma_lices
marines93928023ma_rines
marries93825283marri_es
matrixes1738063matrixes
misprices1547913misprices
murices112612283_murices
naperies10313903naperi_es
nappies114613403nappi_es
oratrices1145833oratrices
orrices9129363_orrices
outprices1337623outprices
papacies1439483papacies
pappies103214833pappi_es
paprica1337003papric_a
paprikas1643853paprikas
paries84742513pa_ri_es
parises94827183pa_rises
parries93925843parri_es
preprices1569263preprices
price93725413__price_
priced115018883__priced
pricer103918293__pricer
pricers113915063__pricers
pricey134412633__pricey
pricks144414263__pricks
prides94324183__prides
pries74339533__pri_es
primes104225263__primes
princes113015143__princes
prises84133173__prises
prizes173819813__prizes
radices102314263ra_dices
raphides14188393raphides
rapines95120863rap_ines
reprice113212833reprice_
repriced132610543repriced
reprises102615463reprises
rices75536153___rices
saices84221803sa__ices
saprobes1237033saprobes
sauries72821623sauri_es
spadices1336093spadices
spices104326033_sp_ices
splices113914383_splices
sprites94220333_sprites
spruces113810503_spruces
tacrines10310563tacrines
tapises92914013tap_ises
tarries73324263tarri_es
taurines8310553taurines
trices84826333__trices
unpriced1338143unpriced
uprises92012733_uprises
vaporises14209453vaporises
vaporizes23228523vaporizes
varies94330873va_ri_es

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.406440125.6
2DLD Change Limit1461622757.67019056.3
3Display Results2752750.1262182.5
 (SQL Overall)1786912758.20221786.3
 
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.