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

101 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
calpacks1826652(None) 
calpack17338331calpack_
calpacs133110341calpac_s
alpacas1137072_alpacas
callbacks1945022callbacks
calpac123211062calpac__
calpains1239762calpains
caracks152211562ca_racks
carjacks2345572carjacks
carracks1637712carracks
clacks144516342c_l_acks
coalsacks1743512coalsacks
kalpacs15327132kalpac_s
kalpaks12366162kalpa_ks
alack114820063_al_ack_
alpaca1047383_alpac_a
arracks1387733_arracks
attacks13126943_attacks
backpacks2044993backpacks
ballparks1743203ballparks
barracks1636883barracks
bipacks1745043_bipacks
blacks144914953_bl_acks
calamus1139243cal_amus
calcars11312653calca_rs
calces104420053cal__ces
calices114321693cal_ices
calicos113913493cal_icos
calks115421603cal___ks
callans94518473calla_ns
callants104112143callants
callas84526753calla__s
callback1845333callback_
calpain11310413calpa_in
calvados1444813calvados
calyces14428803cal_yces
camelbacks2253063camelbacks
caprocks1835943caprocks
carack142113173ca_rack_
carapaces1546053carapaces
carjack2246153carjack_
carpals113414623carpa_ls
carrack1548753carrack_
cassocks1645033cassocks
catfaces1536963catfaces
catwalks1744793catwalks
celiacs11157893celiac_s
champacas2042963champacas
champacs1934633champac_s
champaks2134103champa_ks
clachs133511323c_l_achs
clack134720173c_l_ack_
clanks124615183c_l_anks
clawbacks2243623clawbacks
clicks145315113c_l_icks
cloacas1136233c_loacas
cloaks124411263c_loa_ks
clocks144916233c_l_ocks
clucks144512073c_l_ucks
coalsack1643973coalsack_
coatracks1745403coatracks
compacts16368903compacts
copecks1745873c_opecks
cossacks1645223cossacks
cracks144817003c__racks
cutbacks1845813cutbacks
fallbacks2044353fallbacks
fatbacks1946003fatbacks
flacks154114533_fl_acks
flapjacks2742283flapjacks
galyacs1335273galyac_s
galyaks1534623galya_ks
halfbacks2343993halfbacks
hardpacks2143623hardpacks
hatracks1737533hatracks
hayracks2045313hayracks
kalpac14428223kalpac__
kalpak11437243kalpa_k_
kalpas124112943kalpa__s
lacks116129203__l_acks
manpack1746063manpack_
mudpacks1943233mudpacks
packs135528933___packs
palaces114216453pal_aces
palpates122613063palpates
paybacks2145493paybacks
placks144414153_pl_acks
pollacks1656373pollacks
prepacks1836583prepacks
ransacks1445773ransacks
repacks15269543_repacks
salpas85116923salpa__s
scatbacks1974713scatbacks
slacks124416533_sl_acks
slapjacks2443123slapjacks
tailbacks1744423tailbacks
talkbacks1643783talkbacks
tripacks1664893tripacks
unpacks1576093_unpacks
woolpacks2042593woolpacks
yapocks18354723ya_pocks

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.423422437.4
2DLD Change Limit1461621017.93618417.6
3Display Results1011010.0931086.0
 (SQL Overall)1786911018.45221141.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.