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

253 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
wickless173608(None) 
backless162910632backless
clickless1743982clickless
feckless17225782feckless
ficklest17267902ficklest
iceless9219962_iceless
inkless11348712_inkless
luckless14265892luckless
mickles153415002mickle_s
micklest16219122micklest
milkless1434772milkless
neckless14236432neckless
nickles133713822nickle_s
pickles153215442pickle_s
reckless14257972reckless
riskless1235762riskless
rockless14297292rockless
sickles133417542sickle_s
sickness1437832sickness
sockless14267792sockless
suckless14288822suckless
tackless14419482tackless
ticklers14339302ticklers
tickles133416852tickle_s
viceless1337982viceless
wickers164114702wick_ers
wickets164010942wick_ets
wifeless14277482wifeless
wigless11359672wi_gless
windless123310862windless
wineless112711172wineless
wingless122910022wingless
winkles143412772winkle_s
winless103212282wi_nless
wireless11249632wireless
wishless1435992wishless
witless103310982wi_tless
workless15276802workless
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
barkless14318023barkless
beakless14297383beakless
bibless11439173bi_bless
bickers154316553bick_ers
brickles162810283brickle_s
bucklers16349503bucklers
buckles153416093buckle_s
cacklers163710703cacklers
cackles153717203cackle_s
checkless2044233checkless
cockles153414643cockle_s
cookless14258633cookless
deckles143312803deckle_s
dickens144410133dick_ens
dickers144117663dick_ers
dickeys17479303dick_eys
dickies143416343dickie_s
dickiest153412503dickiest
ductless11196313ductless
faceless13269173faceless
fickle153912973fickle__
fickleness1943663fickleness
fickler16348423fickle_r
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
fishless1436413fishless
fleckless1842893fleckless
flockless1843163flockless
forkless15267433forkless
frockless1843453frockless
giftless1245173giftless
hacklers173710303hacklers
hackles162917063hackle_s
hecklers17357123hecklers
heckles163711383heckle_s
hickeys19508223hick_eys
hickies163614743hickie_s
hideless12278713hideless
hiltless11297123hiltless
hipless12399923hi_pless
hitless103211193hi_tless
hiveless14227933hiveless
hookless151238363hookless
huckles163612623huckle_s
iciness938863_iciness
ickers123914183_ick_ers
ickiest133611043_ickiest
ickiness1436753_ickiness
inkles103515653_inkle_s
innless7288293_innless
ireless72312243_ireless
jacklegs2233963jacklegs
juiceless1843253juiceless
keckles12318763keckle_s
kickers124013293kick_ers
kickiest13319673kickiest
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
knockless1442443knockless
laceless10239853laceless
leakless12246983leakless
lickers134118253lick_ers
lidless8309273li_dless
lifeless11228143lifeless
limbless12246313limbless
limeless10249663limeless
lineless82711943lineless
lintless82710013lintless
lipless9259553li_pless
listless8269263listless
mackles154415753mackle_s
mickeys18447943mick_eys
mickle143715133mickle__
mickler153310233mickle_r
mindless11319443mindless
muckles153413253muckle_s
niceness1039843niceness
nickels13338653nick_els
nickers134415093nick_ers
nickle123814483nickle__
nickled144010443nickle_d
packness1636933packness
peakless14236683peakless
pickeers16347243pickeers
pickers153718093pick_ers
pickets154314183pick_ets
pickiest162712593pickiest
pickiness1737623pickiness
pickle144215653pickle__
pickled164011883pickle_d
pileless1088623pileless
pinkness1436513pinkness
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
priceless1336883priceless
prickles162511093prickle_s
quickness2443733quickness
rankless12268233rankless
ribless93410343ri_bless
richness1337433richness
rickets134915093rick_ets
rickeys16548983rick_eys
riftless1136943riftless
rimless9369363ri_mless
rindless92510193rindless
ruckles133414603ruckle_s
sickbeds17254213sickbeds
sickees134514213sick_ees
sickens134411483sick_ens
sickest131813793sick_est
sickies133717503sickie_s
sickle124418323sickle__
sickled144713433sickle_d
sicklies14710013sicklies
sickliest1547523sickliest
sickliness1645003sickliness
sighless1276553sighless
sinless73014213si_nless
slickness1535903slickness
spiceless1335923spiceless
stackless1555933stackless
sticklers15227393sticklers
stickles142512103stickle_s
sucklers14379963sucklers
suckles134516743suckle_s
tacklers143010773tacklers
tackles133816523tackle_s
tactless10288463tactless
tankless12267823tankless
thickness1844443thickness
tickers133617723tick_ers
ticketless1641933ticketless
tickets134113683tick_ets
tickle124616743tickle__
tickled144313133tickle_d
tickler133612653tickle_r
ticklish1755283ticklish
tideless9269083tideless
tieless72512563ti_eless
timeless10239543timeless
tinklers12298183tinklers
tinkles113713923tinkle_s
tintless8239863tintless
tipless92610063ti_pless
tireless82510263tireless
trackless15246723trackless
trickles143013763trickle_s
tuskless1234213tuskless
twigless1293663twi_gless
twinklers1633063twinklers
twinkles1535073twinkle_s
victress1344523victress
viewless1434033viewless
voiceless1444223voiceless
wackes154717713wack_e_s
wackest164710863wack_est
wackiest172610273wackiest
wackiness1836523wackiness
wageless1237173wageless
waistless1235093waistless
wakeless1536473wakeless
wardless12249303wardless
warless104015103w_arless
wartless11279923wartless
wattless11268723wattless
waveless1437483waveless
wayless13308243w_ayless
weakness1535353weakness
webless1237003w_ebless
weedless12287963weedless
weldless12285813weldless
whickers20297983whick_ers
wiches144418753wic_he_s
wickapes1943703wickapes
wicked164317413wick_e_d
wickedest1943463wickedest
wickedness2043073wickedness
wicker154518673wick_e_r
wicket155318943wick_e_t
wickings18357183wickings
wickiups19181963wickiups
wicks144619363wick___s
wickyups22171773wickyups
widdles123514343widdle_s
wideness12259473wideness
wigglers13257213wigglers
wiggles123312463wiggle_s
wiglets113411423wi_glets
wildness1236203wildness
wiles85437873wi__le_s
wiliness1139113wiliness
willers103517913wi_llers
willets104414323wi_llets
wimbles143010853wimble_s
wimples143311173wimple_s
windlass12266083windlass
windles113518493windle_s
winglets12299593winglets
winkers143517113wink_ers
winkle133812833winkle__
winkled15299593winkle_d
wintles103414983wintle_s
wiriness1138953wiriness
wiseness112010753wiseness
witness103010013wi_tness
woodless12278453woodless
wordless12258843wordless
wrinkles15296693wrinkle_s
zipless18276303zi_pless

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622536.23623438.4
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.73526531.7
 
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.