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

214 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
caravels133743(None) 
caramels1238801caramels
caravel1238201caravel_
carvels124914591car_vels
cadavers1435882cadavers
caracals12310742caracals
caracols12310412caracols
caraculs1238032caraculs
carafes125015702carafe_s
caramel11310252caramel_
carates95630612carate_s
caravans1338612caravans
caravelle1444692caravelle
caravelles1544882caravelles
carcels114516062car_cels
carpels115315462car_pels
carrels95117302car_rels
cartels94618122car_tels
carvel114817572car_vel_
carvers124817532car_vers
carves115128452car_ve_s
cravens124010112c_ravens
cravers124416552c_ravers
craves115825392c_rave_s
gravels113611142_gravels
marvels123810092mar_vels
ravels94717072__ravels
travels104711292_travels
unravels1144632unravels
agaves104611513_agave_s
arables91814973_arables
arames84622573_arame_s
ariels65119373_ar_iels
artels66216233_ar_tels
barbels114514433bar_bels
barrels94514363bar_rels
bravely15428233_bravely
bravers124715523_bravers
braves115524083_brave_s
cabals104020153caba__ls
cabarets12268463cabarets
cadaver1335783cadave_r
calomels1236133calomels
calves115119283ca_lve_s
camails11311753cama_ils
camases114216343camase_s
camels105217083c__amels
canals84421663cana__ls
canapes111213083canape_s
cancels114113313ca_ncels
cannels93413363ca_nnels
carabaos1238073carabaos
carabids1338193carabids
carabins12312353carabins
caracal11312513caracal_
caracks152211563cara_cks
caracol11310423caracol_
caracole12310353caracole
caracoles13310073caracoles
caracul1138823caracul_
carafe115416163carafe__
carageen1155633carageen
carageens1264723carageens
caramelise1464683caramelise
carate84734003carate__
carats85929023cara__ts
caravan1239223carav_an
caravaners1544133caravaners
caraways1636943caraways
carbamyls1843033carbamyls
carbaryls1644013carbaryls
carcanets1347303carcanets
carcases12313083carcase_s
carcel105018673car_cel_
carders104820353car_ders
careens94514703car_eens
careers95218783car_eers
careless102813633careless
carers85133963car__ers
cares77369183car__e_s
caress85720263car__ess
carets85330773car__ets
carfares13310323carfare_s
carfuls1249133car_fuls
cargoes104415223cargoe_s
caribes113715643caribe_s
carices114220953carice_s
caries85147623car_ie_s
carioles10817073carioles
carles85435083car_le_s
carless95118493car_less
carls77037423car___ls
carmakers1736913carmakers
carnages11312213carnage_s
carnets93918403car_nets
carneys124310543car_neys
carnies94123963carnie_s
carnivals1444493carnivals
carolers103314173carolers
carols85124983car__ols
carousels1165343carousels
carpals113414623car_pals
carpel105418473car_pel_
carpers114521253car_pers
carpets113915333car_pets
carpools1237883carpools
carrel84718633car_rel_
carrell94610473car_rell
carrells10359273carrells
carriers103614203carriers
carries94328013carrie_s
carses85233653car_se_s
cartages11313313cartage_s
cartel85022533car_tel_
carters95327253car_ters
cartes86239473car_te_s
carve106227753car_ve__
carved124320853car_ve_d
carven114716663car_ve_n
carver114420143car_ve_r
casavas1237813casav_as
cascabels15163233cascabels
cavers115026843c__avers
caves105639703c__ave_s
cavils114014393c__avils
ceramals1246513ceramals
cerates95428253cerate_s
cervelas1344673cer_velas
chapels14429153c_hapels
charades141310853charade_s
charases131312763charase_s
charnels13328173char_nels
citadels1142843citadels
clavers124314903c_lavers
claves115020063c_lave_s
cleavers13398873cleavers
cleaves124111623cleave_s
coracles121811163coracles
corals85325143cora__ls
corbels113813593cor_bels
cormels113813373cor_mels
cornels94716663cor_nels
coronels104012143coronels
corvees124613793cor_vees
corves115122523cor_ve_s
corvets124715023cor_vets
craals84113303c_ra_als
cradles103114133c_radles
crakes124921813c_rake_s
cranes84330753c_rane_s
crapes104727693c_rape_s
crases85532313c_rase_s
craters95021893c_raters
crates85736063c_rate_s
cravats1237393c_ravats
crave105626313c_rave__
craved125417773c_rave_d
craven114113933c_rave_n
cravenly1644663c_ravenly
craver114618463c_rave_r
crawls114712083c_ra_wls
crazes174720133c_raze_s
creels84416943c_r_eels
crenels93711013c_renels
crewels12438493c_rewels
curares94916853curare_s
curates95323833curate_s
curves114619283cur_ve_s
curvets12399913cur_vets
darnels83710433dar_nels
drivels11397923_drivels
falafels1453113falafels
fardels11389893far_dels
farfels13348213far_fels
garages9314113garage_s
garveys14124463gar_veys
gavels105911093__gavels
gravel105313823_gravel_
gravely14469063_gravely
gravers114515273_gravers
graves104624003_grave_s
grovels11427813_grovels
jarveys20123413jar_veys
karakuls1142083karakuls
karates115617473karate_s
maravedi1442803maravedi
maravedis1542963maravedis
marcels113212373mar_cels
marvel113712003mar_vel_
navels95712693__navels
palavers1337993palavers
parables121613563parables
paraders113113113paraders
parades104121463parade_s
parallels1145273parallels
parapets1239763parapets
parasols1039263parasols
parcels113712663par_cels
parrels94713493par_rels
ratels64518213__ratels
ravel84621513__ravel_
ravens93916883__ravens
ravers94628183__ravers
raves85441973__rave_s
revels94220573__revels
sarapes94617743sarape_s
scarves124511623scar_ve_s
shrivels14376443shrivels
thraves13469713thrave_s
tramels93812493_tramels
travel94112983_travel_
traves94222743_trave_s
unravel1038063unravel_
varves124414783var_ve_s

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622146.89021213.6
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.40224140.9
 
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.