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

209 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
caporal1141094(None) 
caporals1238921caporals
aboral8314372_aboral
amoral8314632_amoral
apodal9289832_apodal
cameral11311282cameral
capital112311522capital
chloral12169982chloral
choral115118492c_horal
coral76033452c__oral
corporal1248512corporal
mayoral1237692mayoral
papyral1445772papyral
sporal82915452_sporal
achiral12109183achiral
agonal7410053_agonal
agora6914333_agora_
agorae7511203_agorae
agoras7613343_agoras
amphoral1565623amphoral
anaphoral1443803anaphoral
anodal72512123_anodal
anorak1038923_anorak
antral65719413_antral
anural65714743_anural
aortal65217513_a_ortal
apical10913903_apical
apneal83411123_apneal
apnoeal956193_apnoeal
apogeal1045623_apogeal
aporia8315863_aporia
aporias9315153_aporias
aport75432173_apor_t
appal95315223_ap_pal
appeal103911613_appeal
apteral9311523_apteral
astral66919283_astral
atonal6514023_atonal
aural54428963_a_ural
auroral7310473auroral
avowal1246323_avowal
axonal1347653_axonal
azonal1568273_azonal
balmoral1244633balmoral
boral75831703__boral
cabal95222153ca__bal
cacodyl1543213cacodyl
caecal103713733ca_ecal
caeoma1039033caeoma_
caeomas1138403caeomas
caesural1055393caesural
calomel1138073calomel
caloric113413223caloric
calorie92716903calorie
calory11312843calor_y
caltrap11297943caltrap
cambial134010763cambial
camera10313693camera_
camerae11312063camerae
cameras11313363cameras
camorra11115773camorra
camorras12116503camorras
camporee1449343camporee
canal75428043ca__nal
canola8313623canola_
canolas9313993canolas
cantal84122033ca_ntal
canthal12410053canthal
cantonal1038903cantonal
cantorial1149813cantorial
cantrap113310283cantrap
capelan1139003capelan
caper94831623caper__
capered123014043capered
caperer113013403caperer
capers105428143caper_s
capful1368173cap_ful
capias10318353cap_ias
capita102913773capita_
capitals12209453capitals
capitol11258283capitol
capo85829213capo___
capoeira1243353capoeira_
capoeiras1343183capoeiras
capon95221873capo__n
caponata1245163caponata
capons104119503capo_ns
capos94826073capo__s
capote10315733capo_te
capotes11314643capotes
capouch1644413capouch
capric12411803cap_ric
capris10415083cap_ris
caprock1736813caprock
capsidal1345623capsidal
capstan1137903capstan
captan101613343cap_tan
captopril1552643captopril
captor104914603captor__
captors113914983captor_s
caracal11312513caracal
carat75048793ca__rat
carbora11310703carbora_
carboras12311583carboras
carceral1247203carceral
carinal94318243carinal
carl65144783ca__r_l
carnal83919213ca_rnal
carol75128613ca__rol
carousal1056283carousal
carpal103716253ca_rpal
carpool1139223carpo_ol
carport11316033carpor_t
carports1238943carports
carrel84718633ca_rrel
casual81112863ca_sual
cateran9313773cateran
cathodal14155413cathodal
caudal91611483ca_udal
causal81413203ca_usal
cavort11316173cavor_t
cavorts1237933cavorts
central93114473central
ceorl7410923c_eor_l
chaparral1652153chaparral
chapteral1644703chapteral
chiral114614413c_hiral
chlorals13148033chlorals
chorale124313353c_horale
chorals124614113c_horals
chordal13449883c_hordal
choreal124412223c_horeal
chorial124214143c_horial
citral81113893c_itral
claptrap1442903claptrap
clitoral10106463clitoral
clonal8310913c_lonal
coal66939253c__o_al
comal95125133c__omal
copal95621783c__opal
coppra12306833coppra_
coppras13327833coppras
copra98115463cop_ra_
coprah133710603cop_rah
copras103517153cop_ras
corals85325143c__orals
coronal94115763coronal
corpora1139353corpora_
corporals1347273corporals
corporeal1344983corporeal
corral83616253c_orral
coxal146116673c__oxal
crapola1136913crapola_
crapolas1247403crapolas
crural8610633c_rural
cupola10317693cupola_
cupolas11277753cupolas
decapodal1552633decapodal
deposal1037153deposal
ephoral1248403ephoral
exposal1645313exposal
femoral1238723femoral
floral94313813_floral
gastral8329553gastral
gooral7310463_gooral
goral65125753__goral
horal86328683__horal
humoral1237973humoral
immoral1146783immoral
lateral7313573lateral
litoral7610763litoral
loral55927823__loral
manorial10311083manorial
moral75533433__moral
nadiral836343nadiral
natural739513natural
nonoral7313603nonoral
oral47638123___oral
pakora1247283pakora_
pakoras1337473pakoras
papal95820673pap__al
parral85517533pa_rral
pastoral10310483pastoral
peroral9314793peroral
portal84218463__portal
preoral9312673preoral
raptorial1147433raptorial
rasorial848223rasorial
reposal939113reposal
sacral83414413sa_cral
sapor75119253sapor__
sapors84118813sapor_s
sapota8310213sapota_
sapotas939613sapotas
sceptral1244513sceptral
sororal7310653sororal
spiral83715343_spiral
suboral92011993suboral
sudoral8148543sudoral
tapetal938273tapetal
temporal1246333temporal
tumoral938133tumoral
unmoral948693unmoral
vapor104013093vapor__
vaporable1645543vaporable
vapored1336923vapored
vaporer1236983vaporer
vapors113812693vapor_s
vapory14398763vapor_y

Search took 7 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.423422437.4
2DLD Change Limit1340272096.31321230.3
3Display Results2092090.0762750.0
 (SQL Overall)1786912096.81226231.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.