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

350 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
zincked233423(None) 
zinced18419411zinc_ed
cinched153910862cinched
dezincked2691642dezincked
dicked144920862di_cked
dinked124818352din_ked
finked144214622fin_ked
inched124514482_inched
inked104218522_in_ked
jinked184013142jin_ked
kicked124415942ki_cked
kinked104014752kin_ked
licked134621562li_cked
linked114518212lin_ked
minced114114912minc_ed
nicked135019682ni_cked
oinked114213282oin_ked
picked154421312pi_cked
pinched153812452pinched
pinked134819882pin_ked
ricked136523622ri_cked
sicked134524402si_cked
snicked143811632snicked
ticked134720522ti_cked
tincted1037272tincted
wicked164317412wi_cked
winced124415342winc_ed
winched163110592winched
winked144018602win_ked
zincky24404962zinck_y
zincoid1946662zincoid
zinged174414622zin_ged
zonked20429472zon_ked
arcked136211943_arcked
backed155725723_backed
banked135021443ban_ked
becked155417763_becked
benched154713943benched
bicker144819173bi_cker
biked125320033bi__ked
bilked134012943bi_lked
binged105920823bin_ged
binned94414543bin_ned
birched15349913birched
bitched153212923bitched
blacked163613373blacked
blinked144010013blin_ked
blocked16449983blocked
boinked14457043boin_ked
bonked135517313bon_ked
bricked164312063bricked
bucked155121063_bucked
bunched154312413bunched
buncoed12378443buncoed
bunked135118373bun_ked
checked193710023checked
chinked174011023chin_ked
chocked194411613chocked
chucked19469733chucked
cinches144215773cinches
circled1237583circled
clacked164113603clacked
clicked164112453clicked
clinched16347383clinched
clinked144011643clin_ked
clocked164112833clocked
clucked163810133clucked
cocked155022563_cocked
conked135019113con_ked
cracked163514743cracked
cricked164814283cricked
crocked164014433crocked
danced105315253danc_ed
decked145217623_decked
dezinced2183903dezinc_ed
diced95824683di_c_ed
dicker134521403di_cker
dickey165913523di_ckey
diked115024683di__ked
dindled104412723dindled
dined76431993din__ed
dinged95221783din_ged
dinkey144812763din_key
dinned84317613din_ned
dinted84419843din_ted
dirked124912273di_rked
disced104914653disc_ed
discoed11312483discoed
disked125015763di_sked
ditched143711903ditched
docked145018333_docked
ducked144718013_ducked
dunked124315283dun_ked
evinced1335403evinc_ed
fancied133310603fancied
fenced124412713fenc_ed
filched16307423filched
finches153914193finches
fined94930503fin__ed
finned104114603fin_ned
flacked173711583flacked
flecked17358073flecked
flicked174610673flicked
flinched17316703flinched
flocked174510253flocked
frocked17439333frocked
fucked164114483_fucked
funked144214113fun_ked
gecked146911933_gecked
ginned83813983gin_ned
hacked164923513_hacked
hanked144220603han_ked
hickey185011993hi_ckey
hijacked2542373hijacked
hiked135919203hi__ked
hinged114618913hin_ged
hinnied11348103hinnied
hinted104318323hin_ted
hitched163312253hitched
hocked165521303_hocked
hoicked1735963hoicked
honked144517913hon_ked
hunched163710493hunched
iced78721893_i_c_ed
icker114018443_i_cker
inbred93010393_inbred
incaged114010443_incaged
incased103612393_incased
incher114114033_incher
inches114419673_inches
incised102911583_incised
incited103314623_incited
incused102911173_incused
indeed83913563_indeed
indued83411653_indued
inker94421093_in_ker
inned64118423_in_ned
inured73114813_inured
invoked1535303_invoked
irked104510923_i_rked
itched123812023_itched
jacked204817523_jacked
jingled164111063jingled
jinker174013543jin_ker
jinxed21346083jin_xed
junked184311693jun_ked
kecked125113163_kecked
kicker114116183ki_cker
kindled133410543kindled
kindred13316953kindred
kinged124215283kin_ged
knacked13287793knacked
knocked13236293knocked
konked104010583kon_ked
lacked135324653_lacked
lanced93717723lanc_ed
licker125222043li_cker
liked104523813li__ked
lined64934643lin__ed
linker104321473lin_ker
linseed838203linseed
linted74021823lin_ted
locked134921663_locked
lucked135118023_lucked
lunched133911823lunched
lynched16376753lynched
miched143913393mi_ched
mickey174211853mi_ckey
miked125020453mi__ked
milked134612573mi_lked
mimicked1943253mimicked
mince95325233minc_e_
mincer104017363minc_er
minces104420803minc_es
mincier113512463mincier
minded103817833min_ded
mined85333353min__ed
mingled113612733mingled
minke115421763min_ke_
minkes124618783min_kes
minored10310103minored
minted94220583min_ted
minuted10329503minuted
miscued1239293miscued
mocked154716613_mocked
mucked153816093_mucked
munched153411073munched
naked105320853__naked
necked134715063_necked
niched125514063ni_ched
nickel123811343ni_ckel
nicker123818703ni_cker
nickled144010443ni_ckled
nocked134617383_nocked
nonsked1236223nonsked
nuked104014183__nuked
packed154822603_packed
pancaked1734893pancaked
panicked1785173panicked
pecked155019103_pecked
picker144422173pi_cker
picket144924313pi_cket
pickled164011883pi_ckled
picnicked2042813picnicked
pieced113912103piec_ed
piked125623313pi__ked
pincer104019173pinc_er
pincher143812713pincher
pinches144117933pinches
pined85935323pin__ed
pinged104321383pin_ged
pinken124513283pin_ken
pinker125322443pin_ker
pinkey154314673pin_key
pinned94818383pin_ned
pinweed1346933pinweed
pitched153512923pitched
plinked143910893plin_ked
plucked16367963plucked
pocked154818983_pocked
ponced114314813ponc_ed
pricked164613833pricked
prinked143412163prin_ked
punched153512173punched
quacked2336793quacked
racked134526083_racked
ranched133113603ranched
ranked114620743ran_ked
recked134821803_recked
reinked1239793rein_ked
riced85825543ri_c_ed
rickey154613973ri_ckey
rinded84418983rin_ded
ringed84623843rin_ged
rinsed75016353rin_sed
risked115514633ri_sked
rocked135022323_rocked
rucked134718763_rucked
sacked135525213_sacked
shacked174015393shacked
shocked174611803shocked
shucked17389833shucked
sicced11489653si_cced
sickbed16396823si_ckbed
sickee124622223si_ckee
sicken124615253si_cken
sicker124023903si_cker
sickled144713433si_ckled
silked114314813si_lked
since75024173sinc_e_
sinewed1137053sinewed
singed85422293sin_ged
singled93914683singled
sinker103620903sin_ker
sinned73818413sin_ned
skinked11339013skin_ked
slacked143815453slacked
slicked144413843slicked
slinked123011383slin_ked
smacked163710993smacked
smocked16398223smocked
snacked144013113snacked
snaked115017593_snaked
snicker133012673snicker
socked134721503_socked
specked16329013specked
stacked143416123stacked
sticked144114633sticked
stocked144312873stocked
sucked134120493_sucked
swacked173110523swacked
swinked15349033swin_ked
synced12266963sync_ed
synched16277213synched
tacked134723943_tacked
talcked1446343talcked
tanked113919293tan_ked
thacked173810203thacked
ticced11438443ti_cced
ticker124321503ti_cker
ticket124524853ti_cket
tickled144313133ti_ckled
tined65434533tin__ed
tinged84220793tin_ged
tingled93712793tingled
tinker103619923tin_ker
tinkled123910473tinkled
tinned74317533tin_ned
tinted74419533tin_ted
tracked143716133tracked
tricked144016163tricked
trocked144312243trocked
trucked143910813trucked
tucked134017493_tucked
uncaked143514353_uncaked
viced115118183vi_c_ed
vined95626153vin__ed
wanked144517153wan_ked
wenched163910913wenched
whacked20458623whacked
wicker154518673wi_cker
wicket155318943wi_cket
wince105220883winc_e_
wincer115018193winc_er
winces114819113winc_es
wincey144110383winc_ey
wincher153410653wincher
winches154714373winches
winded114918213win_ded
windled123713483windled
wined94434183win__ed
winged114620833win_ged
winker134220293win_ker
winkled15299593winkled
winned104017013win_ned
wintled11339843wintled
witched163012193witched
wracked174110113wracked
wrecked17418333wrecked
wricked174910193wricked
yacked164516793_yacked
yanked144312243yan_ked
yince105214253yinc_e_
yocked164114423_yocked
yucked164013563_yucked
zigged184110193zi_gged
zilches21326303zilches
zinc156819093zinc___
zincate1838533zincate
zincates1937733zincates
zincic1935903zinc_ic
zincified2444293zincified
zincify2443913zincify
zincing192910283zincing
zincite1837233zincite
zincites1946633zincites
zincking2435463zincking
zincous1837053zincous
zincs165312933zinc__s
zincy195413513zinc__y
zine137036153zin__e_
zineb165614143zin__eb
zines145232653zin__es
zinger163816703zin_ger
zingier17369493zingier
zinky215314813zin_k_y
zipped203612983zi_pped
zizzled15315853zizzled
zonated173310533zonated
zoned154020263zon__ed

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273507.59317651.4
3Display Results3503500.1262777.8
 (SQL Overall)1786913507.87522690.9
 
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.