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 “inked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

177 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
inked10421852(None) 
dinked124818351dinked
finked144214621finked
inker94421091inker
inned64118421inned
irked104510921irked
jinked184013141jinked
kinked104014751kinked
linked114518211linked
oinked114213281oinked
pinked134819881pinked
winked144018601winked
ankled114313472ankled
anted66328242anted
asked106919312asked
baked126130772baked
banked135021442banked
biked125320032biked
bilked134012942bilked
binged105920822binged
binned94414542binned
blinked144010012blinked
boinked14457042boinked
bonked135517312bonked
bunked135118372bunked
caked126128622caked
chinked174011022chinked
clinked144011642clinked
coked124730692coked
conked135019112conked
deked115718532deked
dicked144920862dicked
diked115024682diked
dined76431992din_ed
dinged95221782dinged
dinkey144812762dinkey
dinned84317612dinned
dinted84419842dinted
dirked124912272dirked
disked125015762disked
duked115218462duked
dunked124315282dunked
dyked145310952dyked
eked96718022_eked
ended74421262ended
faked135225482faked
fined94930502fin_ed
finned104114602finned
funked144214112funked
ginned83813982ginned
hanked144220602hanked
hiked135919202hiked
hinged114618912hinged
hinted104318322hinted
hoked135326992hoked
honked144517912honked
iced78721892i_ced
icker114018442icker
idled74915212idled
igged86012762igged
imbed105013632imbed
imped105117972imped
inbred93010392inbred
inched124514482inched
indeed83913562indeed
index13310982index
indued83411652indued
infer84215032infer
ink76433632ink__
inkers104018832inkers
inkier104013772inkier
inkjet1737452inkjet
inkle94515832inkle
inkles103515652inkles
inks86926502ink_s
inky115321582ink_y
inlet53732402inlet
inner54920622inner
inset54430862inset
intend72310372intend
inter55028492inter
inured73114812inured
invoked1535302invoked
ired55131872i_red
isled64615992isled
ivied94710512ivied
jinker174013542jinker
jinxed21346082jinxed
joked175217912joked
juked175714072juked
junked184311692junked
kicked124415942kicked
kinged124215282kinged
kneed104612052kneed
konked104010582konked
laked105731122laked
licked134621562licked
liked104523812liked
lined64934642lin_ed
linker104321462linker
linted74021822linted
miked125020452miked
milked134612572milked
minced114114912minced
minded103817832minded
mined85333352min_ed
minke115421762minke_
minkes124618782minkes
minted94220582minted
naked105320852naked
need54934152_need
nicked135019682nicked
nided75920872nided
nixed135714222nixed
nuked104014182nuked
picked154421312picked
piked125623312piked
pined85935322pin_ed
pinged104321382pinged
pinken124513282pinken
pinker125322442pinker
pinkey154314672pinkey
pinned94818382pinned
plinked143910892plinked
poked125425392poked
prinked143412162prinked
puked124716222puked
raked105831422raked
ranked114620742ranked
reinked1239792reinked
ricked136523622ricked
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
risked115514632risked
ryked13669512ryked
sicked134524402sicked
silked114314812silked
singed85422292singed
sinker103620902sinker
sinned73818412sinned
skinked11339012skinked
slinked123011382slinked
snaked115017592snaked
sned56026052sn_ed
swinked15349032swinked
tanked113919292tanked
ticked134720522ticked
tined65434532tin_ed
tinged84220792tinged
tinker103619922tinker
tinkled123910472tinkled
tinned74317532tinned
tinted74419532tinted
toked105626492toked
tsked105910032tsked
unfed94614222unfed
unkend11309222unkend
unled64021072unled
unwed94114872unwed
vined95626152vin_ed
waked135626752waked
wanked144517152wanked
wicked164317412wicked
winced124415342winced
winded114918212winded
wined94434182win_ed
winged114620832winged
winker134220292winker
winkled15299592winkled
winned104017012winned
yanked144312242yanked
yoked134821622yoked
zinced18419412zinced
zincked2334232zincked
zinged174414622zinged
zonked20429472zonked

Search took 2 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 Filter178691538000.1101624463.6
2DLD Change Limit538001771.78030224.7
3Display Results1771770.0632809.5
 (SQL Overall)1786911771.95391495.6
 
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.