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

245 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
knickers1330672(None) 
kickers124013291k_ickers
knackers13286841knackers
knockers13285731knockers
nickers134415091_nickers
snickers143010961snickers
bickers154316552_bickers
clickers163910202clickers
dickers144117662_dickers
flickers17338882flickers
ickers123914182__ickers
kicker114116182k_icker_
knacker12307912knacker_
knackery16283662knackery
knifers14537082kni_fers
knitters12336622knitters
knocker12296392knocker_
knucklers1483042knucklers
lickers134118252_lickers
monickers1745082monickers
neckers134210462_neckers
nickels13338652_nickels
nicker123818702_nicker_
pickers153718092_pickers
prickers163710672prickers
shickers173012822shickers
slickers143112552slickers
snackers143010222snackers
snicker133012672snicker_
snickery17295542snickery
stickers142913032stickers
tickers133617722_tickers
trickers143812812trickers
whickers20297982whickers
wickers164114702_wickers
backers153821883_backers
bicker144819173_bicker_
bikers124517553_bi_kers
bilkers134711863_bilkers
blinkers14388503blinkers
blockers16398793blockers
buckers153517453_buckers
checkers19317843checkers
chickees19258513chickees
chickens19267433chickens
clackers163911703clackers
clicker154111883clicker_
clinkers14339833clinkers
clockers16369813clockers
cockers153618333_cockers
crackers164111723crackers
crickets16418123crickets
dackers143417043_dackers
daikers124010313dai_kers
deckers144413833_deckers
deicers103612733deic_ers
detickers1634423detickers
dicers94720743_dic_ers
dickens144410133_dickens
dicker134521403_dicker_
dickeys17479303_dickeys
dikers114418793_di_kers
dockers143715003_dockers
donnickers1782613donnickers
drinkers13277823drinkers
duckers143214713_duckers
duikers12369383dui_kers
enrichers1444133enrichers
enticers10139093entic_ers
flicker163610623flicker_
flickery20365103flickery
friskers15337373friskers
fuckers163611593_fuckers
hackers164619043_hackers
hickeys19508223_hickeys
hikers135014353_hi_kers
hockers163915913_hockers
icker114018443__icker_
inchers123912523in_chers
inciters103210673inciters
indicters1236733indicters
inkers104018833__inkers
invokers1534673invokers
jackers204214453_jackers
jinkers183511813_jinkers
juicers1636153juic_ers
kaisers11369273kai_sers
kayakers1463613kayakers
keisters123212043keisters
kicked124415943k_icke_d
kickier12349053k_ickier_
kicks104420083k_ick__s
kickups1443503k_ickups
kidders13399173k_idders
kiers95320093k_i__ers
kikes85122553k_i_ke_s
killers114215583k_illers
kilters113813603k_ilters
kindlers13318483kindlers
kippers153211433k_ippers
kissers114211293k_issers
kiters105218593k_i_ters
klicks11468723klick__s
klisters123910483klisters
knacked13287793knacke_d
knackered1543683knackered
knackeries1544103knackeries
knacks11428543knack__s
knappers16315643knappers
kneaders1384713kneaders
kneelers12226213kneelers
knifer13598563kni_fer_
knifes136210213kni_fe_s
knishes1438263knishe_s
knitter11348133knitter_
knives13458553kni_ve_s
knocked13236293knocke_d
knockless1442443knockless
knocks11397443knock__s
knollers12255133knollers
knotters12276153knotters
knowers1436343kn_owers
knuckler1383623knuckler_
knuckles1384453knuckles
krimmers16315673krimmers
lackers134120543_lackers
licker125222043_licker_
likers104620913_li_kers
linkers114317713_linkers
lockers133516923_lockers
mickeys18447943_mickeys
milkers134411613_milkers
mimickers1943113mimickers
mincers113714853minc_ers
mockers153812943_mockers
monicker1635733monicker_
monikers1437413moni_kers
muckers153612803_muckers
necker124012793_necker_
nicer74618293_nic_er_
niches114419143_niche_s
nicked135019683_nicke_d
nickel123811343_nicke_l
nickered15117023_nickered
nickles133713823_nickles
nicks114920493_nick__s
niffers13287363_niffers
niggers93111323_niggers
nippers113012623_nippers
niters64624213_ni_ters
ockers123813903__ockers
packers153818893_packers
peckers153312673_peckers
pickeers16347243_pickeers
picker144422173_picker_
pickets154314183_pickets
picnickers2042123picnickers
pikers124717393_pi_kers
pincers113916503pinc_ers
pinchers153510613pinchers
pinkers134118603_pinkers
plinkers14309393plinkers
pluckers16316553pluckers
pricers113915063pric_ers
pricker154013413pricker_
prickets16329083prickets
prinkers143010383prinkers
puckers153514673_puckers
quickens2334253quickens
quicker2247023quicker_
rackers134320453_rackers
ricers84120993_ric_ers
rickets134915093_rickets
rickeys16548983_rickeys
riskers114011993_riskers
rockers133916553_rockers
sackers133820223_sackers
shicker163914823shicker_
shikkers14326523shikkers
shirkers15319583shirkers
shockers17319463shockers
shuckers17388133shuckers
sickees134514213_sickees
sickens134411483_sickens
sicker124023903_sicker_
sinkers113618543_sinkers
skinkers11298183skinkers
slackers143812743slackers
slicers94114923slic_ers
slickens14317263slickens
slicker133314533slicker_
smackers16318713smackers
smirkers14316353smirkers
snacker133112603snacker_
sneakers12308643sneakers
snicked143811633snicke_d
snickered16115343snickered
snickerer15134563snickerer
snickerers16133583snickerers
snicks124312473snick__s
sniffers14257123sniffers
snifters11318613snifters
sniggers10317093sniggers
snipers93311773sni_pers
snippers12299723snippers
snitchers14166043snitchers
snookers12398653snookers
spicers113815553spic_ers
spikers135311993spi_kers
stackers143413563stackers
sticker133515883sticker_
sticklers15227393sticklers
stinkers123111133stinkers
stockers143411073stockers
suckers133717623_suckers
tackers134319623_tackers
thickens17266413thickens
thicker163611023thicker_
thickets17287083thickets
thinkers15308703thinkers
ticker124321503_ticker_
tickets134113683_tickets
ticklers14339303_ticklers
tinkers113517143_tinkers
trackers143512853trackers
tricker134615523tricker_
trickery17297343trickery
truckers14279013truckers
tuckers134014353_tuckers
unifiers11237173unifiers
uniters73814173uni_ters
unmakers14256653unmakers
unpackers17203813unpackers
unpuckers17243123unpuckers
unsicker1435303unsicker_
voicers12348993voic_ers
whackers20326543whackers
whicker19359773whicker_
whiskers18306773whiskers
wicker154518673_wicker_
wickets164010943_wickets
wincers123415363winc_ers
winchers16319223winchers
winkers143517113_winkers
wreckers17315973wreckers

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.1561145455.1
2DLD Change Limit1461622457.83018666.9
3Display Results2452450.0932634.4
 (SQL Overall)1786912458.07922118.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.