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

250 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
knackers1328684(None) 
knacker12307911knacker_
knackery16283661knackery
knickers13306721knickers
knockers13285731knockers
snackers143010221snackers
backers153821882_backers
clackers163911702clackers
crackers164111722crackers
dackers143417042_dackers
hackers164619042_hackers
jackers204214452_jackers
kickers124013292k_ickers
knacked13287792knacke_d
knackered1543682knackered
knackeries1544102knackeries
knacks11428542knack__s
knappers16315642knappers
knocker12296392knocker_
knucklers1483042knucklers
lackers134120542_lackers
neckers134210462_neckers
nickers134415092_nickers
packers153818892_packers
rackers134320452_rackers
sackers133820222_sackers
slackers143812742slackers
smackers16318712smackers
snacker133112602snacker_
snickers143010962snickers
stackers143413562stackers
tackers134319622_tackers
trackers143512852trackers
unpackers17203812unpackers
whackers20326542whackers
ackees124914573__ackees
anankes1138763ananke_s
askers105915403__askers
attackers15144013attackers
backer144525523_backer_
bakers125323453_ba_kers
balkers134915723_balkers
bankers133919093_bankers
barkers134318513_barkers
beakers134216873bea_kers
bickers154316553_bickers
blackens16388103blackens
blacker154513513blacker_
blockers16398793blockers
bracers114616703brac_ers
brackens16327923brackens
brackets163310433brackets
buckers153517453_buckers
cacklers163710703_cacklers
calkers134414693_calkers
cancers114018583canc_ers
cankers134418753_cankers
checkers19317843checkers
clacker153813773clacker_
clickers163910203clickers
clockers16369813clockers
coachers154312303coachers
cockers153618333_cockers
cracker153114173cracker_
dacker134920753_dacker_
daikers124010313_daikers
dancers103413093danc_ers
deckers144413833_deckers
dickers144117663_dickers
dockers143715003_dockers
duckers143214713_duckers
enablers10196913enablers
enactors1038453enactors
exacters1736773exacters
facers115519443_fac_ers
fakers134219533_fa_kers
fanciers13358083fanciers
flackery20295243flackery
flakers143613273fla_kers
flankers15349303flankers
flickers17338883flickers
frankers15348353frankers
fuckers163611593_fuckers
gawkers15347453_gawkers
glaciers11277893glaciers
gnawers11356393gna_wers
hackees165014103_hackees
hacker154822693_hacker_
hacklers173710303_hacklers
hankers144218133_hankers
hawkers174210333_hawkers
hijackers2542323hijackers
hockers163915913_hockers
ickers123914183__ickers
inchers123912523in_chers
inkers104018833in__kers
invokers1534673invokers
jacker194417583_jacker_
jackets205011373_jackets
kaisers11369273k_aisers
kashers143914023k_ashers
kayakers1463613kayakers
kicker114116183k_icker_
knack104311043knack___
knacking14296713knacking
knackwurst185873knackwurst
knapper15387153knapper_
knars94416113kna___rs
knaurs10466963kna__urs
knavery1733123kna_very
knaves13439523kna_ve_s
knawels14344683kna_wels
knawes13328393kna_we_s
kneaders1384713kneaders
kneelers12226213kneelers
knifers14537083kn_ifers
knitters12336623knitters
knocked13236293knocke_d
knockless1442443knockless
knocks11397443knock__s
knollers12255133knollers
knotters12276153knotters
knowers1436343kn_owers
knuckler1383623knuckler_
knuckles1384453knuckles
krakens1034293kra_kens
kraters114212343kra_ters
kyacks14416063kyack__s
lacers85225253_lac_ers
lacker125325623_lacker_
lackeys16458263_lackeys
lakers105225153_la_kers
lancers93616643lanc_ers
lanciers10308543lanciers
larkers113014513_larkers
leachers133712813leachers
leakers113415423lea_kers
lickers134118253_lickers
lockers133516923_lockers
macers105321273_mac_ers
makers123921733_ma_kers
markers133516103_markers
maskers133913843_maskers
menacers12279313menac_ers
mockers153812943_mockers
monickers1745083monickers
muckers153612803_muckers
nabbers113710463_nabbers
naches114622413_nache_s
nacres85614453_nacre_s
naggers93812653_naggers
nailers73215893_nailers
namers84517333_na_mers
nappers114214863_nappers
natters73718063_natters
necker124012793_necker_
nickels13338653_nickels
nicker123818703_nicker_
ockers123813903__ockers
onagers838103ona_gers
pacers105124543_pac_ers
packer144223403_packer_
packets155114773_packets
parkers133816873_parkers
peachers153213843peachers
peckers153312673_peckers
pickers153718093_pickers
placers114515263plac_ers
plackets1646583plackets
pluckers16316553pluckers
poachers152910763poachers
prickers163710673prickers
puckers153514673_puckers
quackery2633113quackery
quakers20309693qua_kers
racers84725433_rac_ers
racker124824553_racker_
rackets134916873_rackets
rakers104123573_ra_kers
ranchers133311793ranchers
rankers113217463_rankers
ransackers1643343ransackers
reachers133515723reachers
rockers133916553_rockers
sacker125124843_sacker_
sakers104125433_sa_kers
shacklers18336033shacklers
shakers144015563sha_kers
sharkers154011053sharkers
shickers173012823shickers
shockers17319463shockers
shuckers17388133shuckers
skankers11316483skankers
skyjackers2541473skyjackers
slackens14367713slackens
slacker133915293slacker_
slakers114115753sla_kers
slickers143112553slickers
smacker153410583smacker_
snacked144013113snacke_d
snacks124514553snack__s
snakes103919603sna_ke_s
snappers123510173snappers
snarers74216663sna_rers
snarlers8298753snarlers
snatchers14146313snatchers
sneakers12308643sneakers
snicker133012673snicker_
snickery17295543snickery
snookers12398653snookers
soakers114114953soa_kers
spacers113813873spac_ers
spankers14369863spankers
sparkers144111313sparkers
stacker134416263stacker_
stalkers12369853stalkers
starkers123712393starkers
stickers142913033stickers
stockers143411073stockers
suckers133717623_suckers
tacker124224503_tacker_
tackets134914363_tackets
tacklers143010773_tacklers
takers103923743_ta_kers
talkers113513213_talkers
tankers113416913_tankers
teachers133212393teachers
thankers15297833thankers
thwackers2142223thwackers
tickers133617723_tickers
tracers94917843trac_ers
tracker133515173tracker_
trickers143812813trickers
truckers14279013truckers
tuckers134014353_tuckers
uncakes133012743uncake_s
unmakers14256653unmakers
unmaskers15243723unmaskers
unpacker16215893unpacker_
unpuckers17243123unpuckers
wacker154920123_wacker_
wackes154717713_wacke_s
wakers134822493_wa_kers
walkers143411473_walkers
wankers144514713_wankers
whacker19368503whacker_
whickers20297983whickers
wickers164114703_wickers
wreckers17315973wreckers
yakkers13304273_yakkers

Search took 8 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.1731032896.0
2DLD Change Limit1461622507.70018982.1
3Display Results2502500.0962604.2
 (SQL Overall)1786912507.96922423.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.