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

121 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
calpack1733833(None) 
calpac123211061calpac_
calpacks18266521calpacks
calpacs133110341calpacs
alack114820062_al_ack
alpaca1047382_alpaca
callback1845332callback
calpain11310412calpain
carack142113172ca_rack
carjack2246152carjack
carrack1548752carrack
clack134720172c_l_ack
coalsack1643972coalsack
kalpac14428222kalpac_
kalpacs15327132kalpacs
kalpak11437242kalpa_k
manpack1746062manpack
aback134816173_a_back
alpacas1137073_alpacas
apace94718383_a_pace
arrack121110253_arrack
attack12148153_attack
backpack1945463backpack
ballpark1643753ballpark
barrack1538253barrack
bipack1636523_bipack
black134719073_bl_ack
calami10313423cal_ami
calash11312433cal_ash
calcar10312753calca_r
calcars11312653calcars
calcic9311873calcic_
calico103414433cal_ico
calipash1543233calipash
calk105527663cal___k
calla74827073calla__
callan83619603calla_n
callans94518473callans
callant94121223callant
callas84526753calla_s
callbacks1945023callbacks
calpains1239763calpains
calvary1537183calvary
camelback2143243camelback
caprock1736813caprock
caracks152211563ca_racks
carapace1446093carapace
carjacks2345573carjacks
caroach1488863caroach
carpal103716253carpa_l
carpale113414353carpale
carpals113414633carpals
carracks1637713carracks
carsick1536343carsick
cassock1545953cassock
catface1436763catface
catwalk1645323catwalk
celiac101910433celiac_
celiacs11157893celiacs
champac1834953champac_
champaca1943203champaca
champacs1934633champacs
champak2034493champa_k
clach124617823c_l_ach
clacks144516343c_l_acks
clank114719523c_l_ank
clawback2143843clawback
click135217953c_l_ick
cloaca1037263c_loaca
cloak115214013c_loa_k
clock134917983c_l_ock
cluck134914893c_l_uck
coalsacks1743513coalsacks
coatrack1645853coatrack
compact153712213compact
copeck1636943c_opeck
cossack1545823cossack
crack134120533c__rack
culpa93610963culpa__
culpae10389263culpa_e
cutback1747093cutback
fallacy1536433fallacy
fallback1944553fallback
fatback1836923fatback
flack144519413_fl_ack
flapjack2642473flapjack
galyac1235973galyac_
galyacs1335273galyacs
galyak1445333galya_k
halfback2244243halfback
hardpack2043923hardpack
hatrack1638213hatrack
hayrack1945543hayrack
kalpa114512193kalpa__
kalpaks12366163kalpaks
kalpas124112943kalpa_s
lack105837683__l_ack
mudpack1843593mudpack
pack125535443___pack
palace104516923pal_ace
palpal104112053palpa_l
palpate113213923palpate
papacy1547493pa_pacy
payback2056453payback
plack135017843_pl_ack
pollack1567333pollack
prepack1757643prepack
ransack1346463ransack
repack142412163_repack
salpa75018353salpa__
salpae84614273salpa_e
salpas85116923salpa_s
scatback1875033scatback
slack115021763_sl_ack
slapjack2343193slapjack
tailback1644923tailback
talkback1543933talkback
tripack1565673tripack
unpack1457833_unpack
woolpack1942823woolpack
yapock17365383ya_pock

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 Limit1340271215.90622693.4
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.37528030.0
 
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.