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

192 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
calpain1131041(None) 
calpains1239761calpains
calkin123515492cal_kin
callan83619602calla_n
calpac123211062calpa_c
calpack17338332calpack
calpacs133110342calpacs
campaign1544212campaign
caplin103216302ca_plin
captain112111052captain
chaplain1546192chaplain
jalapin1645922jalapin
papain10313792pa_pain
salpian938492salpian
again65218113_a_gain
alan46844083_al_a_n
alanin6317273_alanin
alcaic1039983_alcaic
aldrin7311243_aldrin
alevin92511513_alevin
alexin132311483_alexin
algin65718763_al_gin
alkalin11178173_alkalin
aloin55227413_al_oin
alpaca1047383_alpaca
alpine84417373_alp_ine
alumin8513543_alumin
amain74922883_a_main
apian75018333_a_pian
attain6311753_attain
atwain937813_atwain
bargain1079063bargain
blain75421793_bl_ain
cabin94820933ca__bin
cabman123812503cabma_n
caffein1535333caffein
caftan111710123cafta_n
caiman103615663caima_n
cain65643913c___ain
calami10313423cal_ami
calamine12314023calamine
calamint12315133calamint
calash11312433cal_ash
calcar10312753calca_r
calcaria1249523calcaria
calcars11312653calcars
calcic9311873cal_cic
calcine11315273cal_cine
caldaria1148943caldaria
caldron1038153caldron
calfskin1743213calfskin
calif104929093cal__if
calipash1543223calipash
calix145317343cal__ix
calking144617783cal_king
calkins133814873cal_kins
calla74827073calla__
callans94518473callans
callant94121223callant
callas84526753calla_s
calling103826773cal_ling
calming123915973cal_ming
caloric113413213caloric
calorie92716883calorie
calpacks18266523calpacks
calquing2035593calquing
calvaria1347873calvaria
calvarian1446863calvarian
calvary1537183calvary
calving134113503cal_ving
calycine1546963calycine
camail10314823ca_mail
campagna1543413campagna
campagne1544413campagne
campaigns1643473campaigns
camphine1738373camphine
campi116217783camp_i_
camping143118973camp_ing
campion133011413campion
canakin131810833canakin
cancan10314103canca_n
canikin13189753canikin
cannabin1266433cannabin
capelin11510973capelin
capias10318353ca_pias
capiz18514563ca_p_iz
caplins113515993ca_plins
capon95221873ca_p_on
capping143819673ca_pping
capric12411793ca_pric
caprine11314233ca_prine
capris10415073ca_pris
capsid11312413ca_psid
captains121810573captains
captan101613343ca_ptan
caption113513693ca_ption
carabin11313213carabin
carbarn1139453carbarn
carlin84421823ca_rlin
carman103920743carma_n
carotin92216713carotin
carpal103716253carpa_l
carpale113414353carpale
carpalia1247253carpalia
carpals113414623carpals
carpi94319393carp_i_
carping123521083carp_ing
casein83216453ca_sein
catkin123512373ca_tkin
catlin83819073ca_tlin
cattail939173cattail
cayman133613213cayma_n
certain92612213certain
chain105723673c__hain
champaign1942463champaign
chaplains1645713chaplains
charpai1436623charpai_
charpais1536923charpais
chlorin123112993chlorin
chopin132712183chop_in
claim95616913c_l_aim
clan65633923c_l_a_n
clapping153810603clapping
claypan1434313claypa_n
clean75420413c_lea_n
coalbin1137523coal_bin
coalpit1148503coalp_it
cocain101315013c_ocain
colicin11313743colicin
colin76231693col__in
complain1448753complain
complin13312073complin
contain9315823contain
culpa93610963culpa__
culpae10389263culpa_e
culprit1147863culprit
curtain9319793curtain
dalapon1044893dalapon
dauphin1344383dauphin
dolphin1345533dolphin
elain55324703_el_ain
explain1667043explain
gallein8299043gallein
harpin113614383harp_in
hatpin112610603hatp_in
jalapic1844543jalapic
jalapins1745623jalapins
japan14411233ja_pa_n
kalian10312163kalia_n
kalpa114512193kalpa__
kalpac14428223kalpa_c
kalpacs15327133kalpacs
kalpak11437243kalpa_k
kalpaks12366163kalpaks
kalpas124112943kalpa_s
lain46146283__l_ain
lallan63414173lalla_n
lapin75222923la_p_in
malkin122913143mal_kin
napkin1236903na_pkin
pain65647243___pain
paladin101011773paladin
palais8420423pal_ais
palpal104112053palpa_l
palpate113213923palpate
palpating1438533palpating
palpation1339073palpation
palpi95414553palp_i_
palping124112873palp_ing
papains11312363pa_pains
plain74823303_pl_ain
ralphing1435413ralphing
salicin9311223salicin
salpa75018353salpa__
salpae84614273salpa_e
salpas85116923salpa_s
salpians1036763salpians
salpid9510873salp_id
salpinx1636093salp_inx
saltpan935303saltpa_n
sampan102511893sampa_n
scalepan1244513scalepa_n
scalping133410453scalp_ing
sculpin11236653sculp_in
slain54923573_sl_ain
taipan82410663taipa_n
talapoin1045003talapoin
tampan102512323tampa_n
tarpan82814293tarpa_n
taxpaid1743093taxpaid
ulpan7310123_ulpa_n
villain1038473villain

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.1561145455.1
2DLD Change Limit1340271927.51317839.3
3Display Results1921920.0802400.0
 (SQL Overall)1786911927.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.