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

174 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
pickups175425(None) 
kickups1443501kickups
pickup1655631pickup_
backups1736172backups
cockups1735222cockups
fuckups1832922fuckups
hiccups1643222hiccups
kickup1354132kickup_
linkups1333632linkups
lockups1534242lockups
mockups1733342mockups
pickers153718092pickers
pickets154314182pickets
pickles153215442pickles
picks135226142pick__s
piculs103511752pic_uls
pileups11365432pileups
pinups1037412pi_nups
stickups1643302stickups
wickiups19181962wickiups
wickyups22171772wickyups
backup1646613backup_
biceps12447713bic_eps
bickers154316553bickers
checkups2142803checkups
cockup1635713cockup_
coups95522473__coups
crackups1843123crackups
cups85430823__c_ups
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
dickies143416343dickies
dicks125824693dick__s
dictums1235553dictums
dinkums1433673dinkums
epicarps1444783epicarps
fichus14388113fichu_s
ficus105015493fic_u_s
fuckup1733963fuckup_
hiccup1554393hiccup_
hickeys19508223hickeys
hickies163614743hickies
hicks145322173hick__s
hookups1633263hookups
ickers123914183_ickers
ictus7249703_ictu_s
kickers124013293kickers
kicks104420083kick__s
lickers134118253lickers
licks115325393lick__s
lineups934913lineups
linkup1245123linkup_
lockup1434763lockup_
lookups1332953lookups
markups1534963markups
mickeys18447943mickeys
mickles153415003mickles
micks135525373mick__s
mixups1743263mi_xups
mockup1634073mockup_
nickels13338653nickels
nickers134415093nickers
nickles133713823nickles
nicks114920493nick__s
oilcups1143333oilcups
packers153818893packers
packets155114773packets
packs135528933pack__s
peckers153312673peckers
pecks135724433peck__s
picaras11311283picaras
picaros11310893picaros
picas94626523pic__as
piceous11310693piceous
pick125933813pick___
pickax2135913pick_ax
pickaxe2244623pickaxe
pickaxes2344913pickaxes
picked154421313pick_ed
pickeer153710113pickeer
pickeers16347243pickeers
picker144422173pick_er
picket144924313pick_et
pickier153912973pickier
pickiest162712593pickiest
picking163418333picking
pickings17359383pickings
pickle144215653pick_le
pickled164011883pickled
pickoff2143693pickoff
pickoffs2242373pickoffs
picky165416943pick__y
picnics13297343picnics
picots104616443pic_ots
picquet2047743picquet
picquets2143733picquets
pics85633913pic___s
picture1158613picture
pictures1249343pictures
picul95015363pic_u_l
pignus937953pignu_s
pignuts1035613pignuts
pigouts1037593pigouts
pikas114218093pi_k_as
pikers124717393pi_kers
pikes115031033pi_k_es
pikis115116393pi_k_is
pilaus84114133pilau_s
pileup10437923pileup_
pileus84514943pileu_s
pilous84717753pilou_s
pilus75921063pi_lu_s
pimps114616983pi__mps
pinkens13419643pinkens
pinkers134118603pinkers
pinkeys16378213pinkeys
pinkies133818263pinkies
pinkoes135512313pinkoes
pinkos125313873pink_os
pinks115729383pink__s
pinup9612883pi_nup_
pious74621273pi_ou_s
pipkins15328183pipkins
pips85837133pi___ps
piques1739093pi_ques
pockets154612253pockets
pocks135022963pock__s
prickers163710673prickers
prickets16329083prickets
prickles162511093prickles
pricks144414263prick__s
puckers153514673puckers
pucks134322103puck__s
pullups1134233pullups
pups86032233p___ups
pushups1433653pushups
recoups1188843recoups
rickets134915093rickets
rickeys16548983rickeys
ricks115126133rick__s
rictus8379193rictu_s
ruckus12407793rucku_s
scaups105411933_scaups
scups95316653_sc_ups
sickees134514213sickees
sickens134411483sickens
sickies133717503sickies
sickles133417543sickles
sickos125112033sick_os
sickouts1455503sickouts
sicks115127623sick__s
sirups83710533si_rups
situps8538783si_tups
spicks144814993spick__s
stackups1643313stackups
stickums1643943stickums
stickup1533853stickup_
tickers133617723tickers
tickets134113683tickets
tickles133416853tickles
ticks115823293tick__s
tittups933353tittups
walkups1633013walkups
wickape1843723wickape
wickapes1943703wickapes
wickers164114703wickers
wickets164010943wickets
wickiup18172673wickiup_
wicks144619363wick__s
wickyup21171883wickyup_
wikiups16132083wikiups
windups1334783windups
workups1633613workups

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.436409841.7
2DLD Change Limit1340271746.25021444.3
3Display Results1741740.0802175.0
 (SQL Overall)1786911746.76626410.1
 
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.