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

229 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
linkup124512(None) 
lineup835981lineup
linkups1333631linkups
dinkum1335892dinkum
kickup1354132kickup
lineups934912lineups
lingua7509912lingua
link86943442link__
linked114518212linked
linker104321472linker
links96430192link_s
linky127622382link_y
linum7313822lin_um
lockup1434762lockup
lookup1233452lookup
pickup1655632pickup
pinup9612882pin_up
windup1235382windup
ankus91410683_ankus
backup1646613backup
blink115720143blink__
blinked144010013blinked
blinker134110213blinker
blinks124613573blink_s
bunkum1435983bunkum
cinque1736853cinque
clink115320043clink__
clinked144011643clinked
clinker133811663clinker
clinks125815063clink_s
cockup1635713cockup
dingus83611843dingus
dink97137803dink__
dinked124818353dinked
dinkey144812763dinkey
dinkly144311083dinkly
dinks105927953dink_s
dinkums1433673dinkums
dinky135819373dink_y
fink117532123fink__
finked144214623finked
finks125424223fink_s
fuckup1733963fuckup
gink97129523gink__
ginkgo12334943ginkgo
ginks104319563gink_s
hangup1277293hangup
hiccup1554393hiccup
hinky155618753hink_y
hookup1534423hookup
incur72212253_incur
incus73315053_incus
indue63516673_indue
ink76433633_ink__
inked104218523_inked
inker94421093_inker
inkle94515833_inkle
inks86926503_ink_s
inky115321583_ink_y
input7314653_input
inrun52911373_inrun
jink156227203jink__
jinked184013143jinked
jinker174013543jinker
jinks165019333jink_s
kickups1443503kickups
kingcup1642473kingcup
kink76034393kink__
kinked104014753kinked
kinks84926083kink_s
kinky115816383kink_y
langue71012173langue
langur7109303langur
lank84734443lank__
lanker104123003lanker
lankly13439623lankly
lanky125517483lank_y
larrup835713larrup
layup1037723l_ayup
leku86519913l_eku_
letup73712163l_etup
lick106935073lick__
licked134621563licked
licker125222043licker
licks115325393lick_s
lieu46534363li_eu_
lieus56218483li_eus
like86040843li_k_e
liked104523813li_ked
liken911818843li_ken
liker95627063li_ker
likes96231903li_kes
likuta1034213li_kuta
limbus105710383limbus
limp88432493li__mp
lin37967373lin___
linac7315413lin_ac
linacs8310813linacs
linage7713403linage
linden7411453linden
lindy96918313lin_dy
line46965573lin__e
lineal65616023lineal
linear65113343linear
linecut997983linecut
lined64934643lin_ed
linen55728723lin_en
linens64818393linens
lineny94011443lineny
liner55938923lin_er
liners65428853liners
lines57054573lin_es
liney87029633lin_ey
ling57447963lin__g
linga66820823lin_ga
lingam95112353lingam
lingas75116573lingas
linger75226003linger
lingo66022113lin_go
lings67135773lin_gs
linguae8398413linguae
lingual8379083lingual
lingula8428803lingula
lingy96925143lin_gy
linier64423793linier
linin58025523lin_in
lining74526803lining
linins65922143linins
linkage1295963linkage
linkboy1643173linkboy
linkers114317713linkers
linking123818253linking
linkman1335393linkman
linkmen1335363linkmen
linn46034593lin__n
linnet6419423linnet
linns56123333lin_ns
lino46343373lin__o
linocut997673linocut
linos55631503lin_os
lins47059053lin__s
linsey938993linsey
lint416266233lin__t
linted74021823linted
lintel64013993lintel
linter64625343linter
lintol6369473lintol
lints57137193lin_ts
linty87126563lin_ty
linums838283linums
liny78141323lin__y
lip514755803li___p
lisp68926873li__sp
litmus836323litmus
litu47631563li_tu_
lockups1534243lockups
lookups1332953lookups
loup66028433l__oup
lunk86030723lunk__
lunker104718343lunker
lunks94822453lunk_s
markup1436903markup
minium106014423minium
mink106636523mink__
minke115421763mink_e
minkes124618783minkes
minks115829273mink_s
minus75223933min_us
mixup1636773mi_xup
mockup1634073mockup
oilcup1044253oilcup
oink85429343oink__
oinked114213283oinked
oinks94819913oink_s
pickups1754253pickups
pileup10437923pileup
pink107039383pink__
pinked134819883pinked
pinken124513283pinken
pinker125322443pinker
pinkey154314673pinkey
pinkie124414273pinkie
pinkly155012243pinkly
pinko115618253pink_o
pinkos125313873pinkos
pinks115729383pink_s
pinky145823403pink_y
pinups1037413pin_ups
plink115219123plink__
plinked143910893plinked
plinker134010963plinker
plinks124913263plink_s
rink87736993rink__
rinks94827103rink_s
sannup836563sannup
sendup9106343sendup
sinful938803sinful
sink86640143sink__
sinker103620903sinker
sinks95529183sink_s
sinus55523853sin_us
sirup74014913si_rup
situp74414063si_tup
slink95422913slink__
slinked123011383slinked
slinks104315153slink_s
slinky13399103slink_y
slipup1034503sli_pup
stickup1533853stickup
sunup7313053sun_up
tinful938043tinful
tinker103619923tinker
tinkle103714453tinkle
tinkly134811153tinkly
tittup834203tittup
tuneup835203tuneup
vinous93914173vinous
walkup1534193walkup
wickiup18172673wickiup
wickyup21171883wickyup
wikiup15183533wikiup
windups1334783windups
wink116435023wink__
winked144018603winked
winker134220293winker
winkle133812833winkle
winks125325433wink_s
workup1534323workup
zinky215314813zink_y

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162296.50017340.9
3Display Results2292290.0763013.2
 (SQL Overall)1786912296.71626606.8
 
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.